CREATE PROCEDURE pro_bbs_bbsdel
(
@bbs_bbsid varchar(300)
)
AS
DECLARE cur_bbs_bbs CURSOR FOR SELECT userid,rootid,id from bbs_bbs where id in (@bbs_bbsid)
--试试这样行吗
(
@bbs_bbsid varchar(300)
)
AS
DECLARE cur_bbs_bbs CURSOR FOR SELECT userid,rootid,id from bbs_bbs where id in (@bbs_bbsid)
--试试这样行吗
(
@bbs_bbsid varchar(300)
)
AS
declare @sql varchar(1000)
set @sql='SELECT userid,rootid,id from bbs_bbs where id in ('+@bbs_bbsid+')'@sql='DECLARE cur_bbs_bbs CURSOR FOR '+@sql
exec(@sql)
--这样做的话,可能下面对光标的操作都要做成字符串执行
longji(龙寂)
exec(@sql+@sql1+@sql2+...)