FAST_FORWARD- , ,
READ_ONLY- ,
.
SCROLL_LOCKS- ,
UPDATE .
OPTIMISTIC- .
:
DECLARE s1 CURSOR
LOCAL
FAST_FORWARD
FOR SELECT f FROM bd
DECLARE @ a1 CURSOR
SET a1=s1
CURSOR DECLARE s1 CURSOR.
,
OPEN [GLOBAL] _ _ ..
CLOSE [GLOBAL] _ _.
DEALLOCATE [GLOBAL] _ _..
,
FETCH __ ..
FETCH __ -
INTO _ ,
SELECT.
DECLARE a1 CURSOR
LOCAL
FOR SELECT tn, f FROM bd
DECLARE @s1 INT, @s2 CHAR(20)
OPEN a1
FETCH a1 INTO @s1, @s2
PRINT str(@s1,8,2)+@s2
CLOSE a1
DEALLOCATE a1
DECLARE a1 CURSOR
LOCAL
KEYSET
FOR SELECT tn, f FROM bd
DECLARE @s1 INT, @s2 CHAR(20)
OPEN a1
FETCH FIRST FROM a1 INTO @s1, @s2
PRINT str(@s1,8,2)+@s2
FETCH ABSOLUTE 5 FROM a1 INTO @s1, @s2
PRINT str(@s1,8,2)+@s2
CLOSE a1
DEALLOCATE a1
DECLARE a1 CURSOR
LOCAL
KEYSET
FOR SELECT tn, f FROM bd
DECLARE @s1 INT, @s2 CHAR(20)
OPEN a1
FETCH ABSOLUTE 5 FROM a1 INTO @s1, @s2
PRINT str(@s1,8)+ ' '+@s2
FETCH RELATIVE 3 FROM a1 INTO @s1, @s2
PRINT str(@s1,8)+ ' '+@s2
FETCH RELATIVE -3 FROM a1 INTO @s1, @s2
PRINT str(@s1,8)+ ' '+@s2
CLOSE a1
DEALLOCATE a1
FETCH NEXT
DECLARE a1 CURSOR
LOCAL
FAST_FORWARD
FOR SELECT tn, f FROM bd
DECLARE @s1 INT, @s2 CHAR(20)
DECLARE @count int
OPEN a1
SET @count=1
WHILE @count<=6
BEGIN
FETCH a1 INTO @s1, @s2
PRINT str(@s1,8,2)+@s2
SET @count=@count+1
END
--FETCH RELATIVE 3 FROM a1 INTO @s1, @s2
--PRINT str(@s1,8)+ ' '+@s2
FETCH NEXT FROM a1 INTO @s1, @s2
PRINT str(@s1,8,2)+@s2
--FETCH ABSOLUTE 5 FROM a1 INTO @s1, @s2
|
|
|
--PRINT str(@s1,8,2)+@s2
CLOSE a1
DEALLOCATE a1
DECLARE A1 CURSOR
LOCAL
DYNAMIC
FOR SELECT TN,SN FROM i1
FOR UPDATE
OPEN A1
--
FETCH FIRST FROM A1
-- ,
UPDATE I1 SET tn=55,SN=4444 WHERE CURRENT OF A1
--DELETE I1 WHERE CURRENT OF A1
--
Select tn,SN FROM I1
CLOSE A1
DEALLOCATE A1@@CURCOR_ROWS . - , :
-m m ,
-1
0
n - n
()
Transact-Sql. :
- , ;
-
;
- , .
.
sp_
:
sp_addligin
sp_rename
sp_renamedb -
dt _
EXEC _ [, ]
: EXEC sp_helpdb 'aromatherapy'
EXEC sp_dboption 'aromatherapy','read only'
EXEC _ @_= [,@_=]
: EXEC sp_dboption @optname=read only, @dbname=aromatherapy
