下面的 SQL 代码返回值 4.68
select Top 1 [Price_per_KG_AES001] as [(316) 401 - 600] From [dbo].[tbl_stock_list] where [GRADE] = '316'
当我将 Customer 设为参数变量时,下面的 SQL 返回 Price_per_KG_AES001
Declare @TheCustomer varchar(50) = 'Price_per_KG_AES001'
select Top 1 @TheCustomer as [(316) 401 - 600] From [dbo].[tbl_stock_list] where [GRADE] = '316'
如何修改代码以使用变量返回 4.68?
您需要动态 SQL,当前语法似乎不起作用。
所以,你需要:
Declare @TheCustomer varchar(50) = 'Price_per_KG_AES001'
declare @sql varchar(500)
set @sql = 'select Top 1 '+ @TheCustomer +' as [(316) 401 - 600]
from [dbo].[tbl_stock_list]
where [GRADE] = ''316'' '
print @sql -- to see how your query looks before execution
exec (@sql);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句