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 --開打游標(biāo)
FETCH NEXT FROM contact_cursor INTO @sysnumber; --抓取數(shù)據(jù)
-- 檢查 是否有 行獲取。
WHILE @@FETCH_STATUS = 0
----
-- 這是執(zhí)行以前只要獲取成功。
FETCH NEXT FROM contact_cursor INTO @Backsysnumber ; --跳到下一條數(shù)據(jù)
END
CLOSE contact_cursor; --關(guān)閉游標(biāo)
DEALLOCATE contact_cursor; --刪除游標(biāo)
end