[([,]...)]
AS
[WITH CHECK OPTION]
"WITH CHECK OPTION" ( ) ,
INSERT UPDATE ,
WHERE ;
, :
) ( ,
SQL- );
) ;
, .
CREATE VIEW _200
AS
SELECT ot,tn,f,ok FROM bd WHERE ot=200
:
SELECT * FROM _200
:
Transact-SQL. ,
API . ODBC, OLE
. .
3 . . . SELECT, . , , . , ( ). ODBC, ADO . Transact-SQL . :
( ) . N . .
( )
().
Transact-SQL 4 :
- ( ). Tempdb . .
- , . .
- .
- . SELECT, . .
DECLARE _ CURSOR
[ ]. LOCAL GLOBAL
[ ]..FORWARD_ONLY SCROLL
[ ].STATIC, KEYSET, DYNAMIC,
|
|
FAST_FORWARD
[ ]READ_ONLY, SCROLL_LOCKS,
OPTIMISTIC
[TIPE_WARNING] ,
.
SELECT
FOR _腅 ,
.
[FOR UPDATE [OF _]].. ,
.
[OF..], .
LOCAL
GLOBAL
FORWARD_ONLY
SCROLL
STATIC ( SELECT)
tempdb.
KEYSET- tempdb ,
. SELECT
.
DYNAMIC- .