Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step

A

ABS function, 158

ACL permission, 217

ActiveX Database Objects (ADO)

as component of MDAC 1.0, 121122

and programming ODBC applications, 125126

use Command object, 129

use Connection object, 127128

use Recordset object, 129

Add Connection dialog box, 187

Add Counter dialog box, 88

Add Table dialog box, 51, 53, 180

ADO. See ActiveX Database Objects (ADO)

ADO.NET

advantages of, 129

delete data from, 268271

evaluate errors in, 270271

insert data from, 249250

main components of database application connecting to SQL Server 2005 through, 11

and Microsoft Data Access Components (MDAC), 121

as native data provider, 1011

outline architecture, 130

programming ODBC applications, 125

understanding, 139

update data from, 284296

use ADO.NET Namespace, 130131

ADO.NET Command object, 249

ADO.NET Connection object, 249

ADO.NET Namespace, 130131

ADO.NET objects, 249250

AFTER trigger, 266, 277

Aggregate functions, 156

Alias, 39, 150, 170172

ALTER VIEW statement, 183

American National Standards Institute (ANSI), 146147, 151

Analysis Services, 18

AND operator, 145146

ANSI. See American National Standards Institute (ANSI)

ANSI default, 158

API. See Application program interface (API)

Application code. See Code

Application program interface (API), 123, 183

Approximate number datatypes, 103

Arithmetic, to update information, 275276

Artifacts, 75

Attribute

add, 9495

defined, 92, 98

See also entries for specific types of attributes

Authentication Mode, 23

Availability, 7778, 8182