Saving Recordset objects, 133, 187-88
Scalability, and CommandTex property, 78
Schema objects, 330-31
SC queries, 120
Scripts, command, 181-84. See also VBScript
Security, 45-48
SELECT statements
and INTO clause, 321-22
and CommandText property, 78
and Recordsets, 142
referencing other servers, 319-20
and TOP clause, 320-21
when not to use, 79
Servers, different, referencing data from, 319-20
Server-side cursors, 42-43, 72, 110-11, 138, 139, 169, 194, 363-64
Service components, 12
Session pooling, 56, 57, 61-62
SET NOCOUNT statements, 218, 219, 324
Set statement, 19
Shape provider
vs. Data Environment Designer, 311-14
overview, 303-5
sample connection string syntax for msadds.dll, 38
sample Visual Basic application, 306-11
and SQL Server Profiler reports, 314-18
Share locking, 190
Size property, 94-95
Sort property, 201-2
Source property, 96, 119-20, 127, 135-36
SQLOLEDB, 39-41, 324
SQL Server
and ADO, 1
Biblio sample database, 121-22
and Connection objects, 14
getting help, 8
list of datatypes, 94
message and error handling, 230-32
Microsoft Database Engine version, 41-42
multiple instancing feature, 357
ODBC driver, 12, 26, 324
provider properties, 39-41
sample connection string, 37
stored procedure for granting permissions, 324-27
tips for Transact-SQL queries, 320-23
versions of, 320, 355-61
viewing data interfaces in Data View window
SQL Server 2000, 355-62
SQL Server Enterprise Manager, 319-20
SQL Server Povider (SQLOLEDB), 39-41, 324
SQL Server Profiler, 60, 73, 81, 110, 314-15
SQLTrace, 73, 110
State property, 112, 142, 148, 195
Static cursors, 111, 137, 138, 143, 199
Status property, 132, 176, 208
StayInSync property, 306
Stored procedures
as alternative to Recordset objects, 117, 119
as Command object fallback plan, 113
executing, 215-17
for granting permissions on SQL Server, 324-27
vs. hard-coded queries, 80-81
in object queries, 55-56
Oracle, 102-3
and OUTPUT parameters, 218, 220-22
overview, 214, 218
and parameter queries, 96, 233-35
performance improvement, 323-24
as programs, 218
result sets from, 217-26
and return status, 100, 218, 229, 237
support in Data View window, 341-42
Stream objects, 4, 14, 279-80, 292, 294-302
Strings
clip-format, 256-58
encrypting, 332-34
passing, 255-58
tips for using, 332-34
and Visual Basic, 256
Visual Basic operators, 332
Supports method, 137, 140-41, 250
Syntactially Correct queries, 120
System-generated primary keys, 153-55
Team-Fly |