Index

SYMBOLS

@@ functions, 196-199

A

Access (MS), security, 349

action queries, 127-129

Activity Monitor, 49

Add Objects dialog (Securables page), 375

Add Table dialog, 151

New Database Diagram dialog, 82

Relationships window, 86

View Builder, 161

ADO (ActiveX Data Objects), data access development, 223

ADO.NET

Command objects database data retrieval SQL statement example, 229-230

database update SQL statement example, 232

methods, 229

properties, 228

single row/column retrieval SQL statement example, 230-231

Connection objects, 224

ConnectionString property usage example, 227-228

SQL Server Security SQL server connection example, 226-227

Windows NT Security SQL server connection example, 225-226

connection pooling, 226

DataAdapter objects, ...

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.