Activity overview
Latest activity by George Palacean
Options page improvements
If I go to SQL Prompt 4 / Options, it will always display the Main/Behavior page, regardless of the last selected page.
It would be very nice to remember the last active one.
Also it would be very ...
Tooltip for sys.dm_db_index_physical_stats
The tooltip shown for sys.dm_db_index_physical_stats is is not correct.
It says:
dm_db_index_physical_stats (@DatabaseId, @IndexId, @Mode, @ObjectId, @PartitionNumber),
while books online says:
sys...
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)
Synonyms aren't displayed in the candidate list
If I have a synonym for a table, like
create synonym T1 for DB.dbo.Table1
then T1 will not appear in the candidate list when I select from it (select * from T1)
This happens even if I refresh the s...
ALTER procedure formats the code instead of only inserting
Alter statement auto-completion will insert & format the code (two things).
This means that for any minor change inside a procedure not formatted according to the current SQL Prompt settings, the c...
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...
HASHBYTES causes errors
If you try to type the following code in SSMS 2008:
select HASHBYTES ('MD5', 'test')
you get the following error at every key press while inside the parentheses:
See the end of this messa...
Identity seed causes an error
If you try to type the following code in SSMS 2008:
create table test (a int identity (1, 1))
you'll get an "Object reference not set to an instance of an object"
and the followin...
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
)
)
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...