摘要:
declare test CURSOR SCROLL FOR --定义游标 testselect Id from CustomOPEN test --打开游标declare @Id INT --定义变量WHILE @@FETCH_STATUS = 0BEGIN --遍历开始FETCH NEXT FROM test INTO @Id --遍历表格 对游标赋值Iddeclare @dcount INTselect @dcount=COUNT(Custom_ID) from Record Where Custom_ID=@Id --对游标print @dcountprint @idEND --遍历结 阅读全文
posted @ 2013-11-15 13:42
不咬人的蚂蚁
阅读(86)
评论(0)
推荐(0)