111,125
社区成员
发帖
与我相关
我的任务
分享帮忙看一下,这个存储过程那里有问题!
输入number(编号),amount(数量).查询原来表中的amount,用它来减去输入的amount得到一个
新的amount,然后修改表为新的amount.
CREATE PROCEDURE fetchupdatestore1
(
@number nvarchar(10),
@amount int
)
AS
select amount as num from table_store where number=@number
if Rowcount>1
update table_store
set
amount=num-@amount
where number=@number
go
新的amount,然后修改表为新的amount.
CREATE PROCEDURE fetchupdatestore1
(
@number nvarchar(10),
@amount int
)
AS
select amount as num from table_store where number=@number
if Rowcount>1
update table_store
set
amount=num-@amount
where number=@number
go
...全文
请发表友善的回复…
发表回复
mazekui 2004-11-01
- 打赏
- 举报
amount=num-@amount
改成
amount=amount-@amount
改成
amount=amount-@amount
mazekui 2004-11-01
- 打赏
- 举报
if Rowcount>1有问题！
把这行去掉就可以了
把这行去掉就可以了
alan99 2004-11-01
- 打赏
- 举报
CREATE PROCEDURE fetchupdatestore1
(
@number nvarchar(10),
@amount int
)
AS
select amount as num from table_store where number=@number
if Rowcount>1
update table_store
set
amount=amount-@amount
where number=@number
go
(
@number nvarchar(10),
@amount int
)
AS
select amount as num from table_store where number=@number
if Rowcount>1
update table_store
set
amount=amount-@amount
where number=@number
go
tshulinzi 2004-11-01
- 打赏
- 举报
这个不行，num是什么？又没查到原来表中的记录
zag 2004-11-01
- 打赏
- 举报
CREATE PROCEDURE fetchupdatestore1
(
@number nvarchar(10),
@amount int
)
AS
update table_store
set
amount=num-@amount
where number=@number
go
(
@number nvarchar(10),
@amount int
)
AS
update table_store
set
amount=num-@amount
where number=@number
go
