Word wrap

torsten.strauss

Hi!

I set Wrap Lines Longer Than to 78
The following code is formatted in this way:

IF NOT EXISTS ( SELECT * FROM sys.backup_devices WHERE -- WHERE should send to the next line
					name = N'TransactionLog_Backup'  -- name not aligned
			  ) -- bracket not aligned 
	EXEC sp_addumpdevice
		'disk', 'TransactionLog_Backup', '$(BackupPath)\TransactionLog.bak';
GO

I expected a format something like this (depending on the other settings)

IF NOT EXISTS ( SELECT * FROM sys.backup_devices 
                WHERE name = N'TransactionLog_Backup'  ) -- bracket in the end of this line of next line
              )
	EXEC sp_addumpdevice
		'disk', 'TransactionLog_Backup', '$(BackupPath)\TransactionLog.bak';
GO

I guess the Word Wrap option will not recognize other formatting rules anymore.

Thanks for looking into this!

Torsten

torsten.strauss

Style attached

torsten.strauss

comment deleted...

torsten.strauss

Same here:

CREATE TABLE test ( col1 int IDENTITY(1, 1) NOT NULL, col2 char(2000) NOT NULL
														  DEFAULT ( 'A' )
				  );
GO