create proc p_test(@id nvarchar(20),@sex bit,@age int@address int,@phonenvarchar(11)@postnvcarchar(16),@qq nvcarchar(12))asbegin trybegin traninsert into tb1 select @id,@sex,@ageinsert into tb2 select @id,@address,@phoneinsert into tb3 select @id,@post,@qqcommitend trybegin catchrollbackpr...
|