读书人

这个存储过程错在哪多谢

发布时间: 2012-01-31 21:28:41 作者: rapoo

这个存储过程错在哪,谢谢
CREATE PROCEDURE AdgroupArtDeleteUid
(@uid int,@tagid varchar(18))
AS
begin
declare @con varchar(512)
declare @sql varchar(1024)

if(@uid=0)
begin
if(@tagid= ' ')
set @con = ' '
else
set @con = 'where tagid like %, '+@tagid + ',% '
end

else
begin
if(@tagid= ' ')
set @con = 'where uid= '+str(@uid)
else
set @con = 'where uid= '+str(@uid)+ ' and tagid like %, '+@tagid+ ',% '
end

set @sql = 'delete t_adgroupart '+@con
end
exec (@sql)
GO


[解决办法]
like ' '%, '+@tagid+ ',% ' ' '

读书人网 >SQL Server

热点推荐