大家看看这个存储过程有什么问题了!

[tshulinzi]

CREATE PROCEDURE insertstore
(
@number nvarchar(10),
@amount int
)
AS
select number,amount as num from table_store where number=@number

if(@@Rowcount>0)

insert into table_store
values
(
@number,
amount=(num+@amount)
)

else

insert into table_store
values
(
@number,
@amount
)
return
GO

[gaoxiaospring]

/*****************
insert into table_store
values
(
@number,
amount=(num+@amount)
)
*****************/

num的值是多少？在上面一句select中并没有保存这个值。

[shuker]

insert into table_store
values
(
@number,
amount=(num+@amount)//这里不对
)

[gaoxiaospring]

修改一下：
CREATE PROCEDURE insertstore
(
@number nvarchar(10),
@amount int
)
AS

declare num int

select num=amount from table_store where number=@number

if(@@Rowcount>0)

insert into table_store
values
(
@number,
amount=(num+@amount)
)

else

insert into table_store
values
(
@number,
@amount
)
return
GO

[tshulinzi]

上面的不行！

[白云在上]

不懂楼主什么目的。但以下这句，如果 number是主键的话，将出错。
if(@@Rowcount>0)
insert into table_store
values
(
@number,
amount=(num+@amount)
)

猜想楼主是要实现以下目的吧：
if(@@Rowcount>0)
update table_store set amount=amount + @amount where number=@number

[reddg]

declare @num int
set @num=0
select @num=amount from table_store where number=@number
insert into table_store
values
(
@number,
@num+@amount
)