存储过过程报 关键字 'declare' 附近有语法错误。

[Rotel-刘志东]

create procedure proc_sale_sum
declare @sum int
declare @tp1 int
declare @tp2 int
set @sum= @tp1+@tp2

begin
select top 10 a.itemcode,a.dscription,sum(a.quantity) as '@tp1'
from rin1 a
left join (select top 10 b.U_008,b.dscription,sum(b.quantity) as '@tp2'
from rin1 b
where b.itemcode='1000001'
group by b.U_008,b.dscription
)b on a.itemcode=b.U_008
group by a.itemcode,a.dscription

end
GO
exec('select itemcode,(@sum)')

[百年树人]

create procedure proc_sale_sum
as
declare @sum int

中间那个GO要去掉

[华夏小卒]

create procedure proc_sale_sum
declare @sum int,declare @tp1 int,
declare @tp2 int
as

[hao1hao2hao3]

[Quote=引用 2 楼 js_szy 的回复:]
create procedure proc_sale_sum
declare @sum int,declare @tp1 int,
declare @tp2 int
as
[/Quote]

LZ的declare的写法没问题吧！
是下面这样？

declare @sum int,@tp1 int,@tp2 int

[winstonbonaparte]

create procedure proc_sale_sum
as
begin
--变量定义要放到这里面的
declare @sum int
declare @tp1 int
declare @tp2 int
set @sum= @tp1+@tp2

select top 10 a.itemcode,a.dscription,sum(a.quantity) as '@tp1'  
from rin1 a  
left join (select top 10 b.U_008,b.dscription,sum(b.quantity) as '@tp2'
from rin1 b
where b.itemcode='1000001' 
group by b.U_008,b.dscription
)b on a.itemcode=b.U_008
group by a.itemcode,a.dscription

end
GO

[Mark杨]

create procedure proc_sale_sum
@参数1 int,@参数2 int
as

declare @变量 int
declare @变量 int

[xmx2009]

学习了，帮顶

[Rotel-刘志东]

变量定义放as外应该也没有问题吧！

[duanzhi1984]

[Quote=引用 7 楼 lzd_83 的回复:]
变量定义放as外应该也没有问题吧！
[/Quote]

是没问题的。

你的区分变量是否是过程的参数。 如果是，就必须放在AS前，否则放在AS 外。

[米娅]

[Quote=引用 4 楼 winstonbonaparte 的回复:]
SQL code

create procedure proc_sale_sum
as
begin
--变量定义要放到这里面的
declare @sum int
declare @tp1 int
declare @tp2 int
set @sum= @tp1+@tp2

select top 10 a.itemcode,a.dscription,sum(a.quantity)……
[/Quote]

你掉as勒。。。

[syw_java]

呵呵，小细节

[fengxiaohan211]

4楼正解