search

fjtello / SQL-C-sharp

Common programming and coding tips and howtos
0 stars 0 forks source link

SQL syntax [#transaction #commit #rollback #trancount] #21

Open fjtello opened 7 years ago

fjtello commented 7 years ago

DECLARE @t AS TABLE (id INT IDENTITY(1,1), entrada INT, fecha DATETIME DEFAULT(GETDATE()));

BEGIN TRY BEGIN TRAN

INSERT INTO @t (entrada) VALUES (1); 
INSERT INTO @t (entrada) VALUES ('2');
INSERT INTO @t (entrada) VALUES ('tres');

SELECT 'commit';
IF @@TRANCOUNT > 0
    COMMIT TRAN

END TRY

BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK

SELECT 'rollback';

END CATCH

SELECT * FROM @t;