34,576
社区成员
发帖
与我相关
我的任务
分享
declare @SpecialTableName varchar(20),@AntiCode varchar(30),@ProductCode varchar(20)
set @AntiCode='40127739'
set @SpecialTableName='dbo.AntiCodeCommon'
declare @sql nvarchar(2000)
set @sql = 'select @ProductCode = ProductCode from '+ @SpecialTableName+' where AntiCode='''+@AntiCode+''''
exec sp_executesql @sql, N'@ProductCode varchar(20) out', @ProductCode out
select @ProductCode
declare @SpecialTableName varchar(20),@AntiCode varchar(30),@ProductCode varchar(20)
set @AntiCode='40127739'
set @SpecialTableName='dbo.AntiCodeCommon'
declare @sql nvarchar(2000), @ProductCode int
set @sql = 'select @ProductCode = ProductCode from '+ @SpecialTableName+' where AntiCode='''+@AntiCode+''''
exec sp_executesql @sql, N'@ProductCode int out', @ProductCode out
select @ProductCode