sql存储过程新增数据+返回数据集+事务机制

create procedure insert_activeinfo
@Myname varchar(50) output,
@age int output,
@sex int output,
@zy varchar(50) output,
@aaa varchar(50) ,
@a varchar(50)
as
BEGIN TRAN 
 if @@ERROR <> 0 
 begin
   insert into Table_New(Myname,age,sex,zy) values (@Myname,@age,@sex,@zy)
   insert into dbo.Table_1 values(@aaa,@a)
   SELECT top 1 * from Table_New
   SELECT top 1 * from Table_1 
 end
  else
 begin
   commit tran tx
 end
COMMIT TRAN  
exec insert_activeinfo '4',4, 4,'4','aaa','\-a\-a'