PRINT statement examples in SQL Server
SET NOCOUNT ON
BEGIN TRAN
PRINT 'First
Transaction: ' + CONVERT (VARCHAR,
@@TRANCOUNT)
INSERT INTO People
VALUES ('Tom')
BEGIN TRAN
PRINT 'Second
Transaction: ' + CONVERT (VARCHAR,@@TRANCOUNT)
INSERT INTO People
VALUES ('Dick')
ROLLBACK TRAN
PRINT 'Rollback:
' + CONVERT(VARCHAR,@@TRANCOUNT)
========================= Result/message ========================
/*
MESSAGES
First
Transaction: 1
Second
Transaction: 2
Rollback:
0
*/
=====================================================================
No comments:
Post a Comment