create proc [dbo].[Examine](@id as nvarchar(max))
as
begin
declare @sql AS nvarchar(max)
declare @@sysnumber AS nvarchar(50)
set @id=REPLACE(@id,',',''',''')
set @sql = 'declare contact_cursor CURSOR for
select sysnumber
from table where id in ('''+@id+''') '
EXEC(@sql)
OPEN contact_cursor --开打游标
FETCH NEXT FROM contact_cursor INTO @sysnumber; --抓取数据
-- 检查 是否有 行获取。
WHILE @@FETCH_STATUS = 0
----
-- 这是执行以前只要获取成功。
FETCH NEXT FROM contact_cursor INTO @Backsysnumber ; --跳到下一条数据
END
CLOSE contact_cursor; --关闭游标
DEALLOCATE contact_cursor; --删除游标
end
|
