Activity overview
Latest activity by RogueDog
The cross database intellisense was a big selling point for me as well. I too am constantly working across multiple databases on the same and different servers.
One feature beyond same server cross database intellisense that I would like to see is cross server intellisense, as our main database system resides on 4 seperate servers and is synced with a propietary synchronization app that works most of the time. It seems to me that with fully qualified names and the caching structure in SP, it would not be that big of a stretch to incorporate cross server intellisense. / comments
The cross database intellisense was a big selling point for me as well. I too am constantly working across multiple databases on the same and different servers.
One feature beyond same server cros...
Here are my settings. I have listed those items that I have checked. General
Commas
Space after comma
Place Commas at Start
Allign to lists
Indentation
Characters to indent 4
Wrapping
Characters per line 60
Spaces
(Unchecked)
Expressions
Operator placement
On a new line
Place operator at start
Operator spacing
Surround with spaces
Surround with spaces
Parentheses placement
(Nothing Checked)
Parentheses contents
Indent contents of parentheses
Schema Statements
Definition placement
(Nothing Checked)
Data statments
Subquery placement
(Unchecked)
Column placement
(Unchecked)
Parentheses placement
(Unchecked)
Join Placement
Align JOINS with FROMS
Place join conditions on a new line
Align join conditions with join keyword
This particular issue happens with any select statement. I will keep an eye out for other issues and post them as I find them. / comments
Here are my settings. I have listed those items that I have checked.General
Commas
Space after comma
Place Commas at Start
Allign to lists
Indentation
Characters to indent 4
Wrapping
...
Formating Select Statement Combines 'as' With The Field Name
I have found that when using the keyword 'as' in the select statement, and the statement is formated using your tool, in all of the instances past the first field the 'as' is combined with the fiel...
Order By Fields Start On A New Line - Regardless
I have found that even though I have not selected 'On a new line' option in the Column Placement options, the fields are consistently started on a new line in the Order By clause of my queries. T...
Alias Unfriendly
Even though SQL Prompt is an excellent tool, it is alias unfriendly. I write and work with queries in large databases and am more often than not joining several tables in my queries. Even though ...