游标格式

--遍历数据单独给每一行处理
--定义属性
DECLARE @ZBPID as varchar(50)
DECLARE @ZBPNo as varchar(50)
--读取值并复制给对应属性，打开游标，遍历
DECLARE cur CURSOR FOR SELECT ZBPID,ZBPNo FROM TZBiddingPlan WHERE ProjectID='C97D432B-2BF5-4ECA-B105-CC253E5A8E2A' ;
OPEN cur 
fetch next from cur into @ZBPID,@ZBPNo
while(@@fetch_status=0)
BEGIN
--针对每行的操作处理
print(@ZBPID)
print(@ZBPNo)

fetch next from cur into @ZBPID,@ZBPNo --下一条数据
end 
close cur  --关闭游标
DEALLOCATE cur  --释放游标