Package and Deployment Wizard, 7
PageSize property, 146-47
Parameter-based queries
acceptable types of data, 236
ad hoc, 101
and ADO Command objects, 86-87
fetching values, 100-101
overview, 85-86
and Parameters collection, 87-103
passing arguments with Variant arrays, 105-6
and Recordset.Open method, 129
setting parameter values, 97-101
SQL Server Profiler reports, 314-18
substituting values, 73-74
using enumerations, 99-100
Visual Basic addin, 86, 102
ways to construct, 86, 96, 233-34
without Parameters collection, 96-97
Parameter markers, 72, 101, 233, 234-35
Parameter objects. See Parameters collection
Parameters collection
constructing in code, 87, 88-89, 90-95, 214
construction overview, 76, 87, 214
first Parameter object, 92
using Refresh method to construct, 83, 87, 88, 89-90, 232
Visual Basic addin for constructing, 102
Passwords, 45-48
Percent sign (%), for VBScript code tags, 284
Permissions, stored procedure for granting, 324-27
Pooling connections, 50, 56-62
Precision property, 95, 207
Prepared property, 81, 84, 89, 91
Primary keys, 153-55, 173
PRINT statements, 119, 226, 229-32
Prompt property, 46
Properties, 13-16, 39-41, 44, 84-85. See also names of specific properties
Properties collection, 14-16, 26, 179-80, 208
PropertyBag objects, 274-78
Provider Name property, 28
Provider property, 26
Providers, 4, 50-51. See also OLE DB
Team-Fly |