SQL sever 2008 Rar! ?s X<t ? ? ? ?祕BwL0 17240671-1.sql ?0) GO ALTER TABLE Product ADD CONSTRAINT CK_Product_Price CHECK(Price>0) GO ALTER TABLE Proln ADD CONSTRAINT CK_Proln_Quantity CHECK (Quantity>0) GO ALTER TABLE ProOut ADD CONSTRAINT C
类型：
1.普通游标 只有NEXT操作
2.滚动游标 有多种操作
1.普通游标
DECLARE username varchar(20),UserId varchar(100)
DECLARE cursor_name CURSOR FOR --定义游标
SELECT TOP 10 UserId,UserName FROM UserInfo
ORDER BY UserId DESC
OPEN cursor_name --打开游标
FETCH NEXT FR
代码如下:DECLARE OldId varchar(50) DECLARE CustomerID varchar(50) DECLARE My_Cursor CURSOR –定义游标 FOR (select CustomerID,oldid from Customer where Area=’bj’) –查出需要的集合放到游标中 OPEN My_Cursor; –打开游标 FETCH NEXT FROM My_Cursor INTO CustomerID,OldId; –读
