必须声明标量变量 "@sql"。

[想念旧时光]

declare @sql varchar(8000),
@i int ,
@id varchar(50)
set @i=0
set @id='XJD20120904000002'
set @sql= 'select m.MaterielName '
select @i=@i+1,@sql=@sql+ ',sum(case s.SupplierName
when cast( ' +SupplierName+ ' as varchar(100)) then num else 0 end) [action '+cast(@i as varchar(50))+ '] '
from (select distinct SupplierName from dbo.TBA_Supplier) tem
select @sql=@sql+ 'from TPurc_RatioPrice as t,
TPurc_EnquiryList as l,
TBA_Supplier as s,
TBA_Materiel as m
where t.EnquiryListNo=l.EnquiryListNo and
t.SupplierID=s.SupplierID and
l.MaterielCode=m.MaterielCode and
l.EnquiryNo='+@id+'
group by m.MaterielName '

[想念旧时光]

如题，exec(@sql) 的时候提示我必须声明标量变量 "@sql"。
有一年没有碰数据库了，东西都忘记的差不多了，请大家帮我看看错误的所在，谢谢。

[robake]

试试把几个声明都加上declare ，不要偷懒用,

[缘中人]

这样可以啊

declare @sql varchar(8000),
@i int ,
  @id varchar(50)
set @i=0  
set @id='XJD20120904000002'
set @sql= 'select m.MaterielName '  
select @i=@i+1,@sql=@sql+ ',sum(case s.SupplierName   
when cast( ' +SupplierName+ ' as varchar(100)) then num else 0 end) [action '+cast(@i as varchar(50))+ '] '  
from (select distinct SupplierName from dbo.TBA_Supplier) tem  
select @sql=@sql+ 'from TPurc_RatioPrice as t,
TPurc_EnquiryList as l,
TBA_Supplier as s,
TBA_Materiel as m
where t.EnquiryListNo=l.EnquiryListNo and
t.SupplierID=s.SupplierID and  
l.MaterielCode=m.MaterielCode and
l.EnquiryNo='+@id+'
group by m.MaterielName ' 

exec(@sql)

[Wicho开源开发中]

exec("select * from table")

[大渣吼吾系渣渣辉]

sp_executesql的用法

[想念旧时光]

[Quote=引用 3 楼 的回复:]
这样可以啊

SQL code


declare @sql varchar(8000),
@i int ,
@id varchar(50)
set @i=0
set @id='XJD20120904000002'
set @sql= 'select m.MaterielName '
select @i=@i+1,@sql=@sql+ ',sum(case s.S……
[/Quote]

一样在执行的时候报“必须声明标量变量 "@sql"。”