declare test CURSOR SCROLL FOR --定义游标 test
select Id from Custom
OPEN test --打开游标
declare @Id INT --定义变量
WHILE @@FETCH_STATUS = 0
BEGIN --遍历开始
FETCH NEXT FROM test INTO @Id --遍历表格 对游标赋值Id
declare @dcount INT
select @dcount=COUNT(Custom_ID) from Record Where Custom_ID=@Id --对游标
print @dcount
print @id
END --遍历结束
close test
deallocate test