¶¯Ì¬Ö´ÐÐsqlÓï¾äµÄÎÊÌâ

declare @sql varchar(300),@lastqty decimal(18,3),@lastprice decimal(18,3),@month varchar(2)--Õâ¸öÊǶ¯Ì¬Ô·Ý
set @sql='select @lastqty = Stock'+@month +',@lastprice = Price'+@month+' from YMStock where matcode='Z0001''
-- select @lastqty=Stock10,@lastprice= Price10 from YMStock where matcode='Z0001'
--ÒòΪ
exec (@sql)
select @lastqty,@lastprice

--ÌáʾMust declare the variable '@lastqty'.
ÎÒÓ¦¸ÃÔõÑùдÈÃÄÄÁ½¸ö±äÁ¿ÓÐÖµ³öÀ´

---

»¹ÊÇÒªÓö¯Ì¬Óï¾ä°É

---

SQL code:
declare @sql varchar(300),@lastqty decimal(18,3),@lastprice decimal(18,3),@month varchar(2)--Õâ¸öÊǶ¯Ì¬Ô·Ý
set @sql='select @lastqty = Stock'+@month +',@lastprice = Price'+@month+' from YMStock where matcode='Z0001''
-- select @lastqty=Stock10,@lastprice= Price10 from YMStock where matcode='Z0001'
--ÒòΪ
exec ('DECLARE @lastqty decimal(18,3);'+@sql+';SELECT @lastqty')

---

ÓÃsp_executesql

---

SQL code:

Óï·¨²»¶Ô

---

¿´Ò»Ï EXEC sp_executesql

---

ÒýÓÃ

SQL codedeclare@sqlvarchar(300),@lastqtydecimal(18,3),@lastpricedecimal(18,3),@monthvarchar(2)--Õâ¸öÊǶ¯Ì¬Ô·Ýset@sql='select @lastqty = Stock'+@month+',@las