sql server 2008存储过程向变量赋值

Question

create proc AddOrder
@Amount
as
declare @OrderNo char(40)
select @OrderNo=Max(OrderNo) from tbOrderNo
begin
insert tbOrderNo select @OrderNo=@OrderNo+1，@Amount
select '成功'
end
go

我就是要给@OrderNo赋那个表里OrderNo的最大值 好让我插入的时候OrderNo加一 但是跟我说向变量赋值的SELECT语句不能与数据检索操作结合使用 那我要怎么给@OrderNo赋值

Answer 1

尝试一下以下代码：

create proc AddOrder
@Amount
as
declare @OrderNo char(40)
select @OrderNo=Max(OrderNo) from tbOrderNo
begin
insert into tbOrderNo select ISNULL(@OrderNo,0)+1，@Amount
select '成功'
end
go