declare @Type nvarchar(30)
set @Type = '实际数据'
exec('select * from FI_SalesCost where NA_DataType = '+@Type)这个字符串应该怎么写
set @Type = '实际数据'
exec('select * from FI_SalesCost where NA_DataType = '+@Type)这个字符串应该怎么写
set @Type = '实际数据'
exec('select * from FI_SalesCost where NA_DataType = '''+@Type+'''')
set @Type = '''实际数据'''
exec('select * from FI_SalesCost where NA_DataType = '+@Type)
set @Type = '实际数据'
SET @type=QUOTENAME(@type,'''')
exec('select * from FI_SalesCost where NA_DataType = '+@Type)这样也是可以的.