New features added to SQL Prompt Watch now.

Comment Alignment

Hi Red Gate Team,

comments are aligned in a way I did not expected.

Version 1.3179
SET NOCOUNT ON;
SET XACT_ABORT ON;

BEGIN
	BEGIN TRY
		BEGIN TRAN;

		WITH cte
		AS ( SELECT * FROM t1 UNION ALL SELECT * FROM t2 )
		INSERT t3 ( col1 )
		/*
	comment
*/
		SELECT col1 FROM t4
		UNION
		/*
	Server Clusters associated with Database Instances.	
*/
		SELECT col1 FROM t4;
		/*
				comment 
				*/
		COMMIT TRAN;
		RETURN;
	END TRY
	BEGIN CATCH
		IF @@TRANCOUNT > 0
		AND XACT_STATE() <> 0
			BEGIN
				ROLLBACK TRAN;
			END;
		THROW;
	END CATCH;
END;
GO

Thanks for looking into this!

Torsten

Answers

Sign In or Register to comment.