sql server返回添加记录的自增值

create PROCEDURE [dbo].[InsBaseCard]
(
 @usercode  varchar(20),
 @name varchar(50),
 @compname varchar(50),
    @business varchar(50),
    @address  varchar(50),
    @post     varchar(6),
 @tele  varchar(30),
    @mobile varchar(36),
 @cardgroup int,
 @id int output
)
AS
 insert into basecard (usercode,[name],compname,business,trade,[area],[address],post,tele,mobile)
    values (@usercode,@name,@compname,@business ,0,0,@address,@post ,@tele,@mobile)
 set @id = @@identity
 insert into cardinfo (digid,baseid,cardgroup,cardstate,template,trade,area)
    values(@usercode,@id,@cardgroup,0,0,0,0)
 set @id= @@identity
 RETURN @id

 

-------------------------sql server调用测试

declare  @id int
exec Insbasecard 'zrj513','gggggg','123456','123456','123456','123456','123456','123456',4,@id=@id output