Index_S

Team-Fly

Index

S

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


ADO Examples and Best Practices
Ado Examples and Best Practices
ISBN: 189311516X
EAN: 2147483647
Year: 2000
Pages: 106

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net