declare @id varchar(112),@tb varchar(112),@keyword varchar(2)
set @id=1
set @tb='FilePolicy'+@idif object_id(@tb) is not null
begin
declare @s nvarchar(4000)
set @s=N'select @keyword=left(FilePolicy,2) from '+@tb+' where usergroupid=23'
EXEC sp_executesql @s,N'@keyword varchar(2) out',@keyword out
print @keyword
end
set @id=1
set @tb='FilePolicy'+@idif object_id(@tb) is not null
begin
declare @s nvarchar(4000)
set @s=N'select @keyword=left(FilePolicy,2) from '+@tb+' where usergroupid=23'
EXEC sp_executesql @s,N'@keyword varchar(2) out',@keyword out
print @keyword
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货