Comments
1 comment
-
Hi @Dave Pendleton,
The issue here is that you are using separate DECLARE statements whereas this style option is related to a comma separated list of variables and their data types in a single DECLARE statement. So if you were to use:DECLARE @MasterPath nvarchar(512),<br>@LogPath nvarchar(512),<br>@ErrorLog nvarchar(512),<br>@ErrorLogPath nvarchar(512),<br>@Slash varchar = CONVERT(varchar, SERVERPROPERTY('PathSeparator'));
then it will align the data types correctly.
If you would like the option to have this work across DECLARE statements then you will need to raise a Uservoice suggestion for this on the SQL Prompt Uservoice Forum.
Kind regards,
Alex
Add comment
Please sign in to leave a comment.
Checking and un-checking the option does not change the preview of the current query, nor does it affect the code when I format it in the editor. It has quit working in both Visual Studio and SSMS.
Version is: 9.4.5.7296, but it quit working before this version.