Format SQL and ALTER TABLE

Provides intelligent code completion for SQL Server editors.

Format SQL and ALTER TABLE

Postby CodantiM » Tue Mar 30, 2010 6:45 pm

I am using SQL Prompt 4.0.4.14 and have found that the Format SQL doesn't like the ALTER TABLE queries much:

Code: Select all
ALTER TABLE msdb.dbo.backupfile
   ADD Test VARCHAR(10) NULL;


Becomes:

Code: Select all
ALTER TABLE msdb.dbo.backupfile
ADD Test VARCHAR(10) NULL ;


Also:

Code: Select all
ALTER TABLE msdb.dbo.backupfile
   ALTER COLUMN x VARCHAR(192);


Becomes:

Code: Select all
ALTER TABLE msdb.dbo.backupfile
ALTER COLUMN x VARCHAR(192) ;


Appears to be the same issue that keeps coming up with things like ALTER VIEW.
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Anu Deshpande » Thu Apr 01, 2010 9:31 am

Many thanks for your post and apologies for the inconvenience caused.

I have already logged this issue in our internal tracking system and added your comments to it.

Tracking Id for this issue is SP-2945 our developers will look into this and fix it in future release.

I will update you as soon as it is fixed.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Still not fixed in SQL Prompt 5

Postby jmcaleer » Fri Jul 01, 2011 2:21 pm

The problem is still there in SQL Prompt 5! It won't even attempt to format a multiple column add. It just left justifies it! :(
jmcaleer
 
Posts: 1
Joined: Fri Jul 01, 2011 2:16 pm


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests