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
0

Comments

3 comments

  • torsten.strauss
    Style attached
    torsten.strauss
    0
  • torsten.strauss
    comment deleted...
    torsten.strauss
    0
  • torsten.strauss
    Same here:
    CREATE TABLE test ( col1 int IDENTITY(1, 1) NOT NULL, col2 char(2000) NOT NULL
    														  DEFAULT ( 'A' )
    				  );
    GO
    
    torsten.strauss
    0

Add comment

Please sign in to leave a comment.