VistaDB 6
Index
cf
load vsql
missing data types
3.5 sp1
4.0 changes
ABS
accdb
access
access 2007
access modes
ACOS
Add a new Stored Procedure Dialog
add assembly
add assembly
Adding a Foreign Key
adjust spacing
admin tool
ado.net 3.5
ADO.NET Factory Objects in your app.config or web.config
ADO.NET Overview
ado.net providers
Aggregate Functions
ALTER a FUNCTION Example
alter assembly
alter column
alter function
alter statement
alter table
Alter View
App runs locally and fails on remote machine
app.config
app.config
application callback
application callback
application load fails
application sample
application sample
ASCII
ASIN
asp.net example
asp.net example
asp.net programming
asp.net programming
Assemblies
ATAN
ATN2
AVG
begin
BEGIN / END
binding redirect
blob length
blob limit
blob support
block
block sql
blocking
break
build connection string
Build Server Setup
bulk load
bulk operators
business license
Calculating free space in isolated storage
Calling CLR Code using ADO.NET Objects
Calling CLR Functions using SQL Script
Calling CLR Procedures and Functions Overview
calling stored proc
cascade delete
cascade update
cascading delete
cascading delete
cascading update
cascading update
CASE
CAST
casting data
catch error
catch exception
CEILING
CHAR
CHARINDEX
check if column exists
check password
CHECK VIEW
Client Date
Client Date
client server
client-server
CLR Aggregate Functions
CLR Function
CLR Methods and Attributes
CLR Proc
clr proc open database
CLR Procs
CLR Stored Procedures and Functions
clustered index
COALESCE
collapse region
column default
column limits
comment line
comment sql
Community Support Forums
compact framework
Company & Support
comparing datetime values
compatibility modes
compiled procedures
compiled sql
compiler
Components for the .NET Framework
computed columns
conditional
config
configuration
Connected ADO.NET Objects
connection pool
connection string
connection string
connection strings
CONTAINS
contains sample
Context Connection
Context Sensitive Screens
continue
continuous integration
continuous integration
continuous integration
control s
control-e
CONVERT
convert int to string
corporate license
COS
COT
COUNT
COUNT_BIG
counter
create assembly
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
Create or alter User Defined Functions
create proc
create procedure
create procedure
ctrl s
ctrl-e
cube
custom function
custom function
custom round
custom rounding
customer machine fail
cyclic foreign keys
data builder
Data Builder - Export Schema as Scripts
Data Builder - Generate Schema Deployment Script
Data Builder Redistribution
data builder source
data conversion
Data Engine and SQL Query Processor
Data File Information
data grouping
data import
data migration
Data Migration Wizard
Data Migration Wizard - Access Conversion
Data Migration Wizard - Command Line
data types
Data Types and Mapping from SQL Server to VistaDB
data.sqltype
DataAccessKind Enumeration
Database
database config files
Database Connections in a CLR Procedure
database engine
database information
database information
database information
Database limits based upon pagesize
database maximum size
Database rowsize limits
database schema
DataBuilder ExportXml
datadirectory
datalength
Date
Date
DATE *deprecated*
Date and Time Functions
DATEADD
DATEDIFF
DATENAME
DATEPART
datetime without time
DAY
dba admin
dba admin
DBA Sample Tool
dba tool
dba tool
DDAEventDelegate Delegate
DDAEventDelegateType Enumeration
debug clr function
debug clr proc
debug clr trigger
debug just in time
debug output
debugging
debugging clr function
debugging clr proc
Debugging CLR Procs and Functions
decimal precision
decimal scale
declare
declare
default
DEFAULT column entries
DEGREES
delete integrity
delete integrity
deploy EF
Deploying VistaDB with your Application
deployment
deployment
design license
design time license
developer license
developer license
Developer's Guide
Developer's Guide - Logging
Developer's Guide - Logging to Loupe
Developer's Reference - Database Maintenance
development license
diagnostic
difference
differences from sql server
differences from sql server
Direct Data Access Objects - DDA
Disconnected ADO.NET Objects
distributing runtime
distribution
distribution license
dmw
dot net version
dts package
dynamic sql
ef
EF runtime
ef support
else
end
end user license agreement
entity framework
entity framework
entity framework deployment
entity framework distribution
entity framework runtime
error handler
error handling
Error handling in TSQL Procs
errorlevel
Errors Class
Members
Overview
EULA
EULA - End User License Agreement
example
Example CLR Function
Example CLR Function and CLR Procedure
Example CLR Function and CLR Procedure
Example CLR Proc
example connection string
exception
exception
exception handling
exec
exec string
exec text
execute interactive
execute partial sql
ExecuteResultSet
Executing stored procedures
execution plans
existing column test
EXP
export data
export vistadb data
Exporting Data out of VistaDB
extended properties
factory registration
features
features not supported
File
file limits
file permission
file permission
file permissions
file storage
filesize
filesize
FK
FK index
FKeys
FLOOR
flow control
force connections closed
Forcing app database connections closed
Foreign Key Indexes
Foreign Key Integrity Actions
Foreign Key Integrity Operation Types
foreign keys
foreign keys
foreign keys
foreign table
foreign table
forums
forums
FRAC
fts example
fts search example
fts search example
full text
full text search
full text search
full text search
function blocks
functions
functions
Future Reserved Keywords
GETDATE
GetSchema
GetSchema
GetSchema
getschema
GetSchemaTable
GetSchemaTable
Getting Started
Getting Started - Creating A Database
Getting Started - Migrating From Microsoft SQL Server
Getting Started - Migrating From SQL Server - ADO.NET Code
Getting Started - Upgrading to VistaDB 6
Getting Started - What's New - Version 5.0
Getting Started - What's New - Version 5.0.2
Getting Started - What's New - Version 5.0.3
Getting Started - What's New - Version 5.0.4
Getting Started - What's New - Version 5.0.5
Getting Started - What's New - Version 5.0.6
Getting Started - What's New - Version 5.0.7
Getting Started - What's New - Version 5.1
Getting Started - What's New - Version 5.1.1
Getting Started - What's New - Version 5.1.2
Getting Started - What's New - Version 5.1.3
Getting Started - What's New - Version 5.1.4
Getting Started - What's New - Version 5.2
Getting Started - What's New - Version 5.2.2
Getting Started - What's New - Version 5.5
Getting Started - What's New - Version 5.6
Getting Started - What's New - Version 5.7
Getting Started - What's New - Version 5.8
Getting Started - What's New - Version 6.0
Getting Started - What's New - Version 6.1
Getting Started - What's New - Version 6.2
Getting Started - What's New - Version 6.3
Getting Started - What's New - Version 6.4
Getting Started - What's New - Version 6.5
Getting Support
GETUTCDATE
GETVIEWCOLUMNS
GETVIEWS
global temp tables
GO
GROUP BY
grouping
help
help
Help Search FTS Sample
hotkeys
How does VistaDB work?
How To - Backup and Restore a Database
How To - Build and Visualize Foreign Key References
How To - Check for a Bad Encryption Key (Password) at Load Time
How To - Clearing Connection Pools
How To - Create a New Database in Code
How To - Determine your Database Engine Version
How To - Get the Database Schema using SQL
How To - Handle SQL and VistaDB Exceptions
How To - Handle Transactions in SQL
How To - Migrate from VistaDB to SQL Server
How To - Pack a Database
How To - Update Datasets to use VistaDB 6
How To - Use Connection Pooling
How To - Use the VistaDBCommandBuilder
How To - Use VistaDB Providers for ASP.NET Websites
How To - Work with Isolated Storage
How To Create a new database using DDA
How To Create a new database using SQL
How To Perform Common Tasks
How To Test Medium Trust ASP.NET applications
howto proc
if
IF / ELSE
ILog Interface
image limits
import data
incorrect password
index
information schema
INT
integration
integration
integration
interactive query
interactive sql
Introducing FOREIGN KEY constraint may cause cycles
Introduction - Why VistaDB?
ISNULL
isolated storage
isolated storage
isolated storage
isolated storage
IVistaDBAssemblyCollection Interface
IVistaDBAssemblyInformation Interface
IVistaDBClrProcedureCollection Interface
IVistaDBClrProcedureInformation Interface
IVistaDBClrTriggerCollection Interface
IVistaDBClrTriggerInformation Interface
IVistaDBColumn Interface
IVistaDBColumnAttributes Interface
IVistaDBColumnAttributesDifference Interface
IVistaDBConnection Interface
IVistaDBConstraintCollection Interface
IVistaDBConstraintInformation Interface
IVistaDBDatabase Interface
IVistaDBDatabaseObject Interface
IVistaDBDDA Interface
IVistaDBDDAEventDelegate Interface
IVistaDBDefaultValueCollection Interface
IVistaDBDefaultValueInformation Interface
IVistaDBIdentityCollection Interface
IVistaDBIdentityInformation Interface
IVistaDBIndexCollection Interface
IVistaDBIndexInformation Interface
IVistaDBKeyColumn Interface
IVistaDBKeyedCollection<TKey,TValue> Interface
IVistaDBOperationCallbackStatus Interface
IVistaDBPipe Interface
IVistaDBRelationshipCollection Interface
IVistaDBRelationshipInformation Interface
IVistaDBRow Interface
IVistaDBTable Interface
IVistaDBTableNameCollection Interface
IVistaDBTableSchema Interface
IVistaDBValue Interface
just in time debug
keyboard shortcut
Keyboard Shortcuts
known bugs
known issues
Known Visual Studio Issues
LASTIDENTITY
LASTTIMESTAMP
LEFT
LEFT JOIN
LEN
license
license agreement
license rules
Licensing
limitations
limitations
limitations
limits
linq
LINQ Entity Model Tab
LINQ Query Pane
LINQ Script CRUD Examples
load assembly
Load exception Data extended information
load fail
load failure
load procedure
load sql file
Loading CLR Assemblies into VistaDB
local website testing
LOG
log output
log window output
LOG10
Logger Class
Members
Overview
Logging Class
Members
Overview
LogLevel Enumeration
loop
LOWER
LTRIM
Main Content Pane
Mathematical Functions
MAX
max blob size
maximum database
maximum filesize
MAXOF
medium trust
membership
Menu Commands
microsoft access
migration
MIN
MINOF
Modify an existing stored procedure
MONTH
NCHAR
network pack
NEWID
NOCHECK
nonsupported features
not supported
notification
NuGet Packages for VistaDB
NULLIF
Number of open transactions
nunit
nunit
nunit
nunit
ODBC Reserved Keywords
open database in clr proc
open transactions
OperationCallbackDelegate Delegate
optimization
optimization
optimize
optimize
optimizer
Optimizing conditionals in where clauses
Options
ORDER BY
orderby
ordering
ordering results
output log
outputdebug
pack permissions
pagesize
pagesize limitations
pagesize meaning
pagesize performance
Pagesize performance implications
password check
PATINDEX
per developer
per developer
Per Table Options
performance
performance
performance of pagesize
Physical Database File Storage
PI
pivot
pooled connection
pooling connections
POWER
precompile proc
presentation layer
presentation layer
prevent exception
price model
pricing model
PRINT
PRINT
Print Message
PrintMessageEventArgs
profile provider
Programmability
programming examples
programming examples
programming methodology
programming methods
provider cannot be found
query
query history
query optimizer
query plan cache
quick key
quote connection string
quotename
RADIANS
raise an error
raiseerror
raiseerror
raiserror
raiserror
raiserror
RAND
redirect
redistributable
redistribution
region blocks
Registering CLR Methods as SQL Functions
relational integrity
relational integrity
Relationships
Relationships
Relationships
Relationships
Relationships
remote fail
remote failure
remove default
remove time
Remove TIME from a DATETIME
REPLACE
REPLICATE
rethrow error
REVERSE
RIGHT
roadmap
role provider
rollup
ROUND
round error
round problem
rounding
rounding error
rounding numbers
rounding precision
row data limits
rowsize limits
rowsize limits
RTRIM
Running VistaDB Unit Tests
Running VistaDB Unit Tests - Debugging with NUnit
Running VistaDB Unit Tests - What Is NUnit?
Running VistaDB Unit Tests -Running NUnit Tests
Runtime License
Runtime License
runtime version
sample application
sample dba tool
Sample Projects included with VistaDB
sample search
sample tool
Sample web.config for membership providers
sample website
samples
samples
save sql file
save vsql
Scalable to SQL Server or SQL Express
schema
schema
schema
Schema Constants
SCOPE_IDENTITY
search
select over syntax
serialization
serialization
Serialization of Exceptions
SerializationException
serialize
serialize
server
Server Date
Server Date
serverless
serverless
Serverless Database Engine
set
set
SET @VAR
SET OPTIMIZATION
SIGN
Silverlight
SIN
soap formatting
sort order
soundex
sp commands
sp_
SP_RENAME
SP_STORED_PROCEDURES()
SP_UDF()
SPACE
Special Functions
sql
SQL CE Conversion
sql compact
sql compiler
sql conversion
sql editor
sql editor
sql function
sql function
sql functions
sql group
sql interactive
sql precompile
SQL Query Pane
SQL Query Results
SQL Reference
SQL Reference - CASE in a WHERE clause
SQL Reference - Control of Flow Statements
SQL Reference - Database Schema
SQL Reference - Functions
SQL Reference - Operators
SQL Reference - Optimizing SQL Performance in VistaDB
SQL Reference - Reserved Keywords
SQL Reference - Stored Procedures and User-Defined Functions
SQL Reference - System Variables
SQL Reference - Temp Tables
sql region
SQL Script
sql server
sql server
sql server behavior
sql server behavior
SQL Server Commands
sql server differences
sql server differences
sql server differences
sql server differences
SQL Server Foreign Key Differences
sql server import
sql server transfer
sql server types
SQL User Defined Function Example
sqlce
SqlContext Class
Members
Overview
SqlDataRecord Class
Members
Overview
sqldatasource
SqlFunction
SqlFunction
SqlFunctionAttribute Class
Members
Overview
SqlMetaData Class
Members
Overview
SqlMethodAttribute Class
Members
Overview
SqlProcedure
SqlProcedure
SqlProcedureAttribute Class
Members
Overview
SqlTrigger
SqlTriggerAttribute Class
Members
Overview
SQRT
SQUARE
STDEV
storage limits
store provider cannot be found
stored proc
stored proc
stored proc example
stored procedures
stored procedures
stored procs
STR
string
String Functions
strip time from datetime
strongly typed dataset
STUFF
subscribe to print messages
Subscribing to PRINT output in your application
SUBSTRING
SUM
summarizing data
support
support
support ticket
Syntax Editor Advanced Options
System Functions
SystemDataAccessKind Enumeration
tabify
Table
table limits
Table Variable Example
tableadapter bug
Tables Pane
TAN
Technical Details of CLR Procs and Functions
temp files
temp files
Temp Table Example
test for password
testing
testing
testing
third party license
Third Party Tools that require VistaDB design licenses
throw error
ticket sample
ticket system sample
ticket system sample
ticket system sample
tickets
time sql execution
timesheet example
timesheet sample
timesheet sample
Timesheet Website Sample
Tips for SQL Server migration
todo application
todo application
Toolbar Commands
Tools
Tools User's Guide
tostring
TraceLogger Class
Members
Overview
trancount
transaction count
transactions
trap errors
trigger event
TriggerAction Enumeration
TriggerContext Class
Members
Overview
TRY / CATCH
try catch
trycatch
trycatch
tsql function
TSQL Proc Creation
TSQL Proc Removal
turn off optimization
turn off optimizer
tutorial
type mapping
typeid
Types of Applications and Platforms Supported
uac
uac
udf
UDF
UNICODE
unit test
unit test
unit test
unittest
unittest
unittest
Universal DateTime
unsupported
unsupported
unsupported features
unsupported features
Unsupported SQL Server Features and Syntax
update integrity
update integrity
UPPER
upsize
user defined function
user defined function
user defined functions
Using VistaDB with ADO.NET - Common Operations using Any ADO.NET Provider
Using VistaDB with ADO.NET - Common Operations using VistaDB Exclusively
Using VistaDB with ADO.NET - Connection Strings
Using VistaDB with ADO.NET - Getting Started
Using VistaDB with ADO.NET - Introduction
Using VistaDB with ADO.NET - Using Connection Strings in Code
Using VistaDB with Entity Framework - Getting Started
Using VistaDB with Entity Framework - Introduction
Using VistaDB with Entity Framework - Registering the Provider
Using VistaDB with Entity Framework - Upgrading To Entity Framework 6
Using VistaDB with Typed Datasets - Getting Started
Using VistaDB with Typed Datasets - Introduction
UTC date
validation
validation
validation
variable
variables
vdc4
vdc4 file
VDC6 Files
View
Views
VistaDB
VistaDB Data Builder
VistaDB Namespace
Overview
vistadb server
VistaDB Zero Config
VistaDB.6 Assembly
Overview
VistaDB.6.Entity.6 Assembly
Overview
VistaDB.6.Loupe Assembly
Overview
VistaDB.6.Web Assembly
Overview
VistaDB.Compatibility.SqlServer Namespace
Overview
VistaDB.DDA Namespace
Overview
VistaDB.Diagnostic Namespace
Overview
VistaDB.Entity Namespace
Overview
VistaDB.Extra Namespace
Overview
VistaDB.Loupe Namespace
Overview
VistaDB.Provider Namespace
Overview
VistaDB.VistaDBTypes Namespace
Overview
VistaDB.Web Namespace
Overview
VistaDBBinary Class
Members
Overview
VistaDBBoolean Class
Members
Overview
VistaDBByte Class
Members
Overview
VistaDBClrProcedureAttribute Class
Members
Overview
VistaDBClrProcedureKind Enumeration
VistaDBCommand Class
Members
Overview
VistaDBCommandBuilder Class
Members
Overview
VistaDBConnection Class
Members
Overview
VistaDBConnection GetSchema Examples
VistaDBConnection.CompatibilityMode Enumeration
VistaDBConnection.SchemaConstants Class
Members
Overview
VistaDBConnectionFactory Class
Members
Overview
VistaDBConnectionStringBuilder Class
Members
Overview
VistaDBContext Class
Members
Overview
VistaDBContext.DDAChannel Class
Members
Overview
VistaDBContext.SQLChannel Class
Members
Overview
VistaDBDataAdapter Class
Members
Overview
VistaDBDatabaseOpenMode Enumeration
VistaDBDataPermission Class
Members
Overview
VistaDBDataReader Class
Members
Overview
VistaDBDataReader GetSchemaTable example
VistaDBDataTable Class
Members
Overview
VistaDBDataTableException Class
Members
Overview
VistaDBDate Class
Members
Overview
VistaDBDateTime Class
Members
Overview
VistaDBDateTimeOffset Class
Members
Overview
VistaDBDecimal Class
Members
Overview
VistaDBDouble Class
Members
Overview
VistaDBEngine Class
Members
Overview
vistadbexception
vistadbexception
VistaDBException Class
Members
Overview
VistaDBExecutionPlan Class
Members
Overview
VistaDBGuid Class
Members
Overview
VistaDBInfoMessageEventArgs Class
Members
Overview
VistaDBInfoMessageEventHandler Delegate
VistaDBInt16 Class
Members
Overview
VistaDBInt32 Class
Members
Overview
VistaDBInt64 Class
Members
Overview
VistaDBMembershipProvider Class
Members
Overview
VistaDBOperationStatusTypes Enumeration
VistaDBParameter Class
Members
Overview
VistaDBParameterCollection Class
Members
Overview
VistaDBParameterCollection.ParameterEnumerator Class
Members
Overview
VistaDBPipe Class
Members
Overview
VistaDBPlanBlock Class
Members
Overview
VistaDBPlanBlock.BlockType Enumeration
VistaDBPlanBlock.PlanBlockCollection Class
Members
Overview
VistaDBPlanFunctionBlock Class
Members
Overview
VistaDBPlanResultBlock Class
Members
Overview
VistaDBPlanResultBlock.ResultType Enumeration
VistaDBPlanTableBlock Class
Members
Overview
VistaDBProfileProvider Class
Members
Overview
VistaDBProviderFactory Class
Members
Overview
VistaDBProviderManifest Class
Members
Overview
VistaDBProviderServices Class
Members
Overview
VistaDBReferentialIntegrity Enumeration
VistaDBRoleProvider Class
Members
Overview
VistaDBRowUpdatedEventArgs Class
Members
Overview
VistaDBRowUpdatedEventHandler Delegate
VistaDBRowUpdatingEventArgs Class
Members
Overview
VistaDBRowUpdatingEventHandler Delegate
VistaDBSingle Class
Members
Overview
vistadbsqlexception
vistadbsqlexception
VistaDBSQLException Class
Members
Overview
VistaDBString Class
Members
Overview
VistaDBText Class
Members
Overview
VistaDBTime Class
Members
Overview
VistaDBTransaction Class
Members
Overview
VistaDBTransaction.TransactionMode Enumeration
VistaDBType Enumeration
VistaDBValue Class
Members
Overview
VistaDBXmlReadMode Enumeration
VistaDBXmlWriteMode Enumeration
Visual Studio
visual studio issues
vsql file
VSQL6 Files and sql file management
ways to program
web support
web.config
web.config
website example
website maintenance
What about LINQ?
when to pack
while
WHILE / BREAK / CONTINUE
why pack a database
Why VistaDB - Encryption
Why VistaDB - The Importance of Managed and Typesafe Code
Window
wizard datadirectory
Working with a database in isolated storage
wpf
wpf
YEAR
zero config
zero config
zero config
Zero Config deployment