34,587
社区成员
发帖
与我相关
我的任务
分享
create table sysBill(billtype char(5),bill_number int)
go
create proc GetBillno(@billtype char(5),@bill_no char(20) output)
as
begin
set @bill_no=bill_number +1 from sysBill where billtype=@billtype
update sysBill set bill_number=bill_number +1 where billtype=@billtype
--bill_number 保证了唯一的安全
end