弱弱的问一句,我这个存储过程哪里错了?

Question

CREATE proc sp_Adduser
@name varchar(100),
@pwd   varchar(50),
@sask varchar(40),
@sans   varchar(50),
@grade varchar(20),
@icount   int,
@mail varchar(40),
@result int output
as
 @result =(insert into card_message(sname_card,spassword,Email,sask,
sanswer,sgrade,icount)  values(@name,@pwd,@mail,@sask,@sans,
@grade,@icount) select @@identity)
GO

Answer 1

tryCREATE proc sp_Adduser
@name varchar(100),
@pwd   varchar(50),
@sask varchar(40),
@sans   varchar(50),
@grade varchar(20),
@icount   int,
@mail varchar(40),
@result int output
as
 insert into card_message(sname_card,spassword,Email,sask,sanswer,sgrade,icount) values(@name,@pwd,@mail,@sask,@sans,@grade,@icount) 
 select @result =@@identity
GO