34,575
社区成员
发帖
与我相关
我的任务
分享
DECLARE @prjCode VARCHAR(100)
DECLARE prjCode_cursor CURSOR LOCAL FORWARD_ONLY READ_ONLY STATIC
FOR
SELECT prjCode FROM [A]
OPEN prjCode_cursor
FETCH NEXT FROM prjCode_cursor INTO @prjCode
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC getPrjTask @prjCode
FETCH NEXT FROM prjCode_cursor INTO @prjCode
END
CLOSE prjCode_cursor
DEALLOCATE prjCode_cursor