. , , . , , , , , , , , , .
SQL Server 2000 . , Transact-SQL, b. (DTS, Data Transformation Services).
. . , . , . , , .
SQL Server 2000 . , , . OLE DB , ODBC, , , .
Transact-SQL select, , . :
SELECT * FROM table_name
, ., , . , , , , .
insert, select, update delete, , , , . Query Analyzer . , . , .
|
|
, , . () . , , , . .
. . , .
. , , , . , , , . . -, , . , , . , .
. . , . , , , Query Analyzer, . , , , . . , , , .
, . . , . , . . , . Transact-SQL, , SQL Server 2000 (stored procedure).
|
|
. , , , .
, . , . . , . .
SQL Server 2000 :
- , ;
- , , ;
- , .
SQL Server 2000 . , . , , . , , , .. . , - . , , select .
, , (cursors). , . , , , .
, , (complete set of rows). select , (resulting set). . where. . , . SQL Server 2000 , .
:
- Transact-SQL (Transact-SQL Cursors). Transact-SQL. . . Transact-SQL , ;
|
|
- API (API Server Cursors). (ODBC, OLE DB, DB Library . .). API, . API Transact-SQL. API, , , . Transact-SQL, API ;
- (Client Cursors). . . . , , . pa .
:
1. (Forward-only). , . . , . , , ;
2. (Scrollable). . , . ( ), ( ). , .
. Primary Key, Foreign Key . . , , .
, , . . , .
(triggers) SQL Server 2000 Transact-SQL, . , . , , . . .
, , . , , . , , , . , . , ( ). , , , .