Question

想在存储过程里实现这样一个功能，添加一条数据使ID自动加1（不要设置标识），

ALTER PROCEDURE pro_InsertStu
(
@stuID int,
@stuNum char(11),
@stuName varchar(50),
@stuSex char(10),
@stuClass varchar(50),
@tchID int
)
AS
Declare @MaxStuID int
Select @MaxStuID=Max(stu_ID) From Student
if(@MaxStuID is null)
Set @stuID = 1
else if(@stuID is null)
Set @stuID = @MaxStuID + 1
Insert Into Student (stu_ID,stu_Num,stu_Name,stu_Sex,stu_Class) Values (@stuID,@stuNum,@stuName,@stuSex,@stuClass)
RETURN
执行的时候添加一条数据为什么会在表的第一条之前添加

Answer 1

ALTER PROCEDURE pro_InsertStu
(
    @stuID int,
    @stuNum char(11),
    @stuName varchar(50),
    @stuSex char(10),
    @stuClass varchar(50),
    @tchID int
)
AS
    Declare @MaxStuID int
    SET @MaxStuID = 0
    Select @MaxStuID=Max(stu_ID) From Student
    SET @MaxStuID = ISNULL(@MaxStuID,0) + 1
    
    Insert Into Student (stu_ID,stu_Num,stu_Name,stu_Sex,stu_Class) Values (@stuID,@stuNum,@stuName,@stuSex,@stuClass)
RETURN