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 %, '[email protected] + ',% '
end
else
begin
if(@tagid= ' ')
set @con = 'where uid= '+str(@uid)
else
set @con = 'where uid= '+str(@uid)+ ' and tagid like %, '[email protected]+ ',% '
end
set @sql = 'delete t_adgroupart '[email protected]
end
exec (@sql)
GO
------解决方案--------------------
like ' '%, '[email protected]+ ',% ' ' '