51,397
社区成员




CREATE PROCEDURE [dbo].[test]
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRAN;
INSERT INTO 表1( 字段 )VALUES ( 值 )
INSERT INTO 表2( 字段 )VALUES ( 值 )
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN;
RETURN -1;
END;
COMMIT TRAN;
END;