create table a(id int ,aa varchar(10))select * from a create proc USP_insertA AS declare @MaxID int select @MaxID =isnull(max(id),0) + 1 from a insert into a select @MaxID ,'AA' + convert(varchar,@MaxID) union select @MaxID + 1,'AA' + convert(varchar,@MaxID+1) union select @MaxID + 2,'AA' + convert(varchar,@MaxID+2) drop table a
create proc USP_insertA
AS
declare @MaxID int
select @MaxID =isnull(max(id),0) + 1 from a
insert into a select @MaxID ,'AA' + convert(varchar,@MaxID)
union select @MaxID + 1,'AA' + convert(varchar,@MaxID+1)
union select @MaxID + 2,'AA' + convert(varchar,@MaxID+2) drop table a