Posts
Sort by recent activity
Feature Request: Formatting options to the Nth degree
I would love for sql prompt formatting to mimic the level of detail that resharper does with it's code formatting for C#.
Looking in resharper options:
Naming style: 15 types
Braces: 13 options
Bla...
Automatic Aliases from capitals
Rather than individually defining aliases per table, is it possible to use capitalised letters of tables/views to define an alias.
eg.
Customer = C
mem_Membership = M
cus_StateCustomer = SC
aReally...
Detail for non proc/udf types.
The detail column and preview panel should show for types that are not stored procedures/udf's.
For example the table type should show the 'create table' script.
Constraints should show the creatio...
Type column creating duplicate rows
For some stored procedures a match is being found for name, column and text.
Can this column be grouped together and show as "all" or "3 items" or "name,column,text"?
If your text string matches 5 ...
Possible bug: @PV variable declaration.
Hi.
Unfortunately i'm not able to provide too much information regarding this possible bug. This is occurring on a clients machine in which i do not have access to, and am unable to get a copy of t...
Updates with fields losing table context
I started with the following statement:UPDATE Table SET
Complete = 0,
UpdateCustomer = 1,
UpdateMember = 1,
Update
If i press the hotkey when i've typed the word "upd" it will work correctly ...
List of bugs
Can a sticky please be created with a list of all found bugs?
Its hard to go through the forum and see which have or have not been found and the common ones have 3-4 posts each reporting the same i...
Feature request: local variables
This isn't a bug, but just a nice to have.
DECLARE @... [ctrl-space]
Should come up with a list of types.
Variables should come up in candidate list for joins, fields, etc once created.
One other t...
OR statement and tables starting with same letter
If you type:WHERE (1 = 1 or
And pause for a second after typing "OR" the candidate list will pop-up. If you have a tabled named "order" or something starting with "or" when you press the spac...
Selecting view on join didnt complete text
While editing a proc.
I had the following bit of code (in a more complex proc):
LEFT JOIN cus_Customer C ON C.CustomerID=M.CustomerID
LEFT JOIN sec_Person P ON N.ActionedByID=P.PersonID
INNER JOIN ...