这个存储过程怎么报错了

[zhangwuji154]

if exists(select * from sysobjects where [xtype]='p' and [name]='MyPro')
	drop proc MyPro

go 
create proc MyPro
as
	@price int
	select t.title as 书名, sum(s.qty) as 销售额度
	From titles as t
	inner join sales as s on s.title_id=t.title_id
	group by t.title
where t.price > @price

说@price int这行有错

[AcHerat]

create proc MyPro(@price int)
as
    select t.title as 书名, sum(s.qty) as 销售额度
    From titles as t
    inner join sales as s on s.title_id=t.title_id
    group by t.title
where t.price > @price

[Spade_J]

declare @price int

[mabailin]

[Quote=引用 1 楼 acherat 的回复:]

SQL code

create proc MyPro(@price int)
as
select t.title as 书名, sum(s.qty) as 销售额度
From titles as t
inner join sales as s on s.title_id=t.title_id
group by t.title
where t.price > @……
[/Quote]

做输入参数得这么用

[a_Spring]

declare @price int
declare 是声明变量的关键字 。

[zhangwuji154]

[Quote=引用 1 楼 acherat 的回复:]

SQL code

create proc MyPro(@price int)
as
select t.title as 书名, sum(s.qty) as 销售额度
From titles as t
inner join sales as s on s.title_id=t.title_id
group by t.title
where t.price > @……
[/Quote]
http://www.cnblogs.com/Nina-piaoye/archive/2006/09/18/507183.html
那为什么这里介绍的，是这种方法呢

[Spade_J]

create proc MyPro
@price int
as
在as前

[zhangwuji154]

[Quote=引用 1 楼 acherat 的回复:]

SQL code

create proc MyPro(@price int)
as
select t.title as 书名, sum(s.qty) as 销售额度
From titles as t
inner join sales as s on s.title_id=t.title_id
group by t.title
where t.price > @……
[/Quote]
我改了

create proc MyPro(@price int)
as

select t.title as 书名, sum(s.qty) as 销售额度
From titles as t
inner join sales as s on s.title_id=t.title_id
group by t.title
where t.price > @price

还是报错，报where t.price > @price有错

[AcHerat]

--介绍是没错的，楼主要注意怎么写
create proc MyPro
    @price int     --要写在as前边！！！
as
    select t.title as 书名, sum(s.qty) as 销售额度
    From titles as t
    inner join sales as s on s.title_id=t.title_id
    group by t.title
where t.price > @price

[AcHerat]

select t.title as 书名, sum(s.qty) as 销售额度
From titles as t
inner join sales as s on s.title_id=t.title_id
where t.price > @price  --不要放在group by后边，基础的语法！
group by t.title