34,590
社区成员
发帖
与我相关
我的任务
分享
--看示例:
--1.创建存储过程
ALTER PROCEDURE [dbo].[SMS_RTNextRecord]
-- Add the parameters for the stored procedure here
AS
fetch next from RTCursor
--2.调用存储过程
DECLARE RTCursor CURSOR FOR
SELECT [Field] FROM test
OPEN RTCursor
exec SMS_RTNextRecord
CLOSE RTCursor
DEALLOCATE RTCursor
--fetch next from RTCursor
DECLARE RTCursor CURSOR FOR SELECT o.name FROM sysobjects AS o
DECLARE @sstr VARCHAR(30)
OPEN RTCursor
FETCH NEXT FROM RTCursor INTO @sstr
SELECT @sstr
CLOSE RTCursor
DEALLOCATE RTCursor