Comments
Sort by recent activity
Hello,
Is this characteristic only to SQL Server 2008 or does it happen on other editors as well?
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
Is this characteristic only to SQL Server 2008 or does it happen on other editors as well?
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
Hello,
Email sales@red-gate.com and I am sure they will be able to answer that question [image]
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hello,
Email sales@red-gate.com and I am sure they will be able to answer that question
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
jerryhung wrote:
SSMS Tools has a "debug section" feature and becomes commented out if you run under the "Release" mode, very like VS
Ctrl-K, Ctrl-D
#-BeginDebug
#-EndDebug
Perhaps we can see
#-BeginNoLayout
#-NoLayout
Disable some sections for layout is good, especially when I create mass-insert code and intentionally make it 1 row insert for 1 line if I can
and I believe SQL Prompt lays it out, 1 line per comma
Imagine if I created a insert stmt for entire table (thru SSMS tool), 1000 rows, and lay it out [image] SELECT 10,'52','Saint Philip','PH' UNION ALL
SELECT 11,'52','Saint Thomas','TH'
lays out to
UNION ALL
SELECT 10,
'52',
'Saint Philip',
'PH'
UNION ALL
SELECT 11,
'52',
'Saint Thomas',
'TH'
Hello,
I can see what you mean:)
We will log this into our database and hopefully address it in our future versions.
Meanwhile, if it helps at all for the particular example stated, you can set the options to lay out the values in the same line(Layout - Data Statements - Uncheck 'Place subsequent columns on a new line') and when you lay out, it would look like:
SELECT 10, '52', 'Saint Philip', 'PH'
UNION ALL
SELECT 11, '52', 'Saint Thomas', 'TH'
Thanks,
Tanya
Project manager
Red Gate Software Ltd / comments
jerryhung wrote:
SSMS Tools has a "debug section" feature and becomes commented out if you run under the "Release" mode, very like VS
Ctrl-K, Ctrl-D
#-BeginDebug
#-EndDebug
Perhaps we can see...
Hi,
We are currently planning for SQL Prompt v4.0 and will include this into our review list.
Out of interest, how do you like the column aliases to be aligned? Maybe if it is something which most people would prefer that could possibly go as default style or as an option?
Thanks,
Tanya
Project Manager
Red Gate Software Ltd / comments
Hi,
We are currently planning for SQL Prompt v4.0 and will include this into our review list.
Out of interest, how do you like the column aliases to be aligned? Maybe if it is something which most ...
Hi,
We have fixed this issue in our patch release for v3.8. If you can kindly contact support@red-gate.com they will be able to give you the link to access the patch release.
Upgrading to the patch release build should resolve the issue.
Thanks,
Tanya / comments
Hi,
We have fixed this issue in our patch release for v3.8. If you can kindly contact support@red-gate.com they will be able to give you the link to access the patch release.
Upgrading to the patch...
Hi,
Thank you for your suggestion.
I know this can be quite annoying for keyboard users and it has bitten me quite a few times I should say.
We have logged this into our database and plan to work out something to address this concern in our future versions.
Thanks,
Tanya / comments
Hi,
Thank you for your suggestion.
I know this can be quite annoying for keyboard users and it has bitten me quite a few times I should say.
We have logged this into our database and plan to work o...
Hello,
SQL Prompt is not designed to work that way in our current version.
However, it is something we plan to look into for our future versions.
Thanks,
Tanya / comments
Hello,
SQL Prompt is not designed to work that way in our current version.
However, it is something we plan to look into for our future versions.
Thanks,
Tanya
Hello,
The patch release that gets SQL Prompt to work on RC0 is now available and you can get the same by emailing support@red-gate.com
Please note that this build will allow SQL Prompt to work on RC0 and does not support the new SQL Server 2008 syntax.
There will be a SQL prompt release that includes SQL Server 2008 support after the RTM.
Thanks,
Tanya
Project manager
Red Gate Software Ltd / comments
Hello,
The patch release that gets SQL Prompt to work on RC0 is now available and you can get the same by emailing support@red-gate.com
Please note that this build will allow SQL Prompt to work on ...
Thank you for your feedback:)
Regards,
Tanya
Project Manager
Red Gate Software Ltd / comments
Thank you for your feedback:)
Regards,
Tanya
Project Manager
Red Gate Software Ltd
Strange! I am unable to replicate this issue. Does it happen occassionally or does it keep showing up often? Also, can you tell me the editor where this problem occurs?
Thanks,
Tanya / comments
Strange! I am unable to replicate this issue. Does it happen occassionally or does it keep showing up often? Also, can you tell me the editor where this problem occurs?
Thanks,
Tanya