Comments
Sort by recent activity
Are table variables going to be supported in the final version ? (currently I see that they aren't) / comments
Are table variables going to be supported in the final version ? (currently I see that they aren't)
It's because it's underlining correct SQL (temp tables which I know are not implemented yet, but sometimes even comments).
For example, in SSMS 2008:
create table #t1 (a int)
select *
from #t1
-- comment - marked as 'syntax error'
/*this comment is also underlined*/
select *
from #t1
/ comments
It's because it's underlining correct SQL (temp tables which I know are not implemented yet, but sometimes even comments).
For example, in SSMS 2008:
create table #t1 (a int)
select *
from...
Another example of comment underlining: create table test (
a int,
constraint PK_TEST primary key clustered (
a --that's the primary key - underlined as syntax error
)
)
/ comments
Another example of comment underlining:create table test (
a int,
constraint PK_TEST primary key clustered (
a --that's the primary key - underlined as syntax error
)
)
Is there any option to turn syntax highlight off ? / comments
Is there any option to turn syntax highlight off ?
Hi Tanya,
I don't want SQL Prompt to reformat every procedure which I'm altering.
Even if, let's say, the code is not properly formatted, SQL Prompt will change the whole body of the procedure, thus messing up the source version control; Besides this, any change in the user preferences will make all the stored procedures to completely change their layout when altered.
This can be a very useful feature, but in the current implementation it's quite useless.
tanya wrote:
Hi George,
All automatically SQL Prompt inserted code respect the format settings of the user while being inserted. We do not have any settings currently to disable this functionality. However, I can log this into our bug tracking system and have it reviewed for our next version.
I hope that helps.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
George Palacean wrote:
Is it possible to make SQL Prompt NOT format the source code of the procedure when it auto-completes the alter procedure statement ?
I couldn't find any option for this
/ comments
Hi Tanya,
I don't want SQL Prompt to reformat every procedure which I'm altering.
Even if, let's say, the code is not properly formatted, SQL Prompt will change the whole body of the procedure, thu...
Is it possible to make SQL Prompt NOT format the source code of the procedure when it auto-completes the alter procedure statement ?
I couldn't find any option for this / comments
Is it possible to make SQL Prompt NOT format the source code of the procedure when it auto-completes the alter procedure statement ?
I couldn't find any option for this
A very strange thing:
When SQL Prompt 4 is enabled, double-clicking a word in SSMS 2008 doesn't select it entirely, it stops at underscores.
For example, double-clicking SP_HELP selects either 'SP', '_' or 'HELP' (depending on the mouse position), instead of the whole procedure name.
This happens only as long as SQL Prompt is enabled.
By the way, why has the quick menu option to disable SQL Prompt disappeared ? Now it can only be disabled by going to SQL Prompt->Options / comments
A very strange thing:
When SQL Prompt 4 is enabled, double-clicking a word in SSMS 2008 doesn't select it entirely, it stops at underscores.
For example, double-clicking SP_HELP selects either 'SP'...
GO [count] is not supported in SQL Prompt and displays "SQL syntax error". (GO without [count] works ok) / comments
GO [count] is not supported in SQL Prompt and displays "SQL syntax error". (GO without [count] works ok)
I have the same problem / comments
I have the same problem
But that will export only the summary (what you see on the upper part of the screen).
Is it possible somehow to export the details, based maybe on whether or not the table is checked for synchronization ?
Besides that, exporting the list of tables which could not be compared doesn't seem very useful, since you have the possibility to map them anyway when editing the project. / comments
But that will export only the summary (what you see on the upper part of the screen).
Is it possible somehow to export the details, based maybe on whether or not the table is checked for synchroniz...