不咬人的蚂蚁

摘要： 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 --遍历结 阅读全文