=============================================
CREATE PROCEDURE dbo.InsertUser
@sName varchar(50),
@sPassWord varchar(20),
@Count int
AS
select @Count=Max(Id) from Users
begin
insert into Member (Id,Name,PassWord)
values
(@Count+1,@sName,@sPassWord)
end
GO
===============================================
这个显然是有问题的。如果有一些数据以后删除一条非末尾记录,然后再添加就会出现重复ID
CREATE PROCEDURE dbo.InsertUser
@sName varchar(50),
@sPassWord varchar(20),
@Count int
AS
select @Count=Max(Id) from Users
begin
insert into Member (Id,Name,PassWord)
values
(@Count+1,@sName,@sPassWord)
end
GO