What are the challenges you face when working across database platforms? Take the survey
Options

Begin Tran

Hi Redate Team,

I wonder why a BEGIN TRAN is not formatted like a BEGIN statement
BEGIN TRAN T1
INSERT dbo.test ( col2 ) VALUES ( DEFAULT )
SELECT database_transaction_log_bytes_used
FROM sys.dm_tran_database_transactions
WHERE database_id = DB_ID()
COMMIT TRAN T1

Should look like this:
BEGIN TRAN T1
	INSERT dbo.test ( col2 ) VALUES ( DEFAULT )
	SELECT database_transaction_log_bytes_used
	FROM sys.dm_tran_database_transactions
	WHERE database_id = DB_ID()
COMMIT TRAN T1

Would be nice to see this implementation in the next release.

Thanks!

Torsten

Answers

Sign In or Register to comment.