sql 存储过程实例----Insert

简单的存储过程如下：

create proc insert_demo@name varchar(50),@falg bit output as begin   set nocount on     begin tran     insert into  aa (Name) values (@name)    if @@error<>0      begin        set @falg=0;       rollback      end     else       begin        set @falg=1       commit      end   set nocount off end