BEGIN TRANSACTION
DECLARE @ERR INT
INSERT INTO USER_MASTER(USERNAME, PASSWORD) VALUES('Damerla','Damerla')
SET @ERR = @@Error
IF @ERR > 0
BEGIN
ROLLBACK TRANSACTION
PRINT 'ROLLBACK TRANSACTION'
END
ELSE
BEGIN
COMMIT TRANSACTION
PRINT 'COMMIT TRANSACTION'
END
Subscribe to:
Post Comments (Atom)
-
Hi, How to correct spell mistake in SSC Certificate To correct you name in SSC certificate you need to submit the following documents to...
-
-- Retuns all Tables in a database -- Here U means User defined SELECT [name],id,xtype FROM sysobjects WHERE xtype='U' ORDER BY ...
-
District Institutes of Educational Training - DIET CET - 2013 NOTIFICATION Online applications are invited from candidates who intend to ...
No comments:
Post a Comment