| Author |
Message |
CodantiM
Joined: 29 Jun 2007
Posts: 180
|
 Posted: Tue Mar 30, 2010 6:45 pm Post subject: Format SQL and ALTER TABLE |
 |
|
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: |
ALTER TABLE msdb.dbo.backupfile
ADD Test VARCHAR(10) NULL; |
Becomes:
| Code: |
ALTER TABLE msdb.dbo.backupfile
ADD Test VARCHAR(10) NULL ; |
Also:
| Code: |
ALTER TABLE msdb.dbo.backupfile
ALTER COLUMN x VARCHAR(192); |
Becomes:
| Code: |
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. |
|
| Back to top |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 595
Location: Cambridge
|
| Posted: Thu Apr 01, 2010 9:31 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
jmcaleer
Joined: 01 Jul 2011
Posts: 1
|
| Posted: Fri Jul 01, 2011 2:21 pm Post subject: Still not fixed in SQL Prompt 5 |
|
|
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!  |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
