Posts
Sort by recent activity
matching things that are obviously not the same
Things that have no correlation to one another shouldn't have the ability to overwrite the item. For example, in the supplied script, there are indexes:
In one database:
create index DefinitelyDif...
FOR XML AUTO, TYPE
When I lay out:select *
from tableName
FOR XML AUTO, TYPE
I would expect that FOR XML AUTO, TYPE stay on one line with one spaces between the words. It actually is changed to:
select *
from...
First Line placement in Order By clause
When I lay out:SELECT ContactID, FirstName, LastName, Phone
FROM Person.Contact
ORDER BY ContactID
It does this:SELECT ContactID
, FirstName
, LastName
...
Subquery placement
Not to be overly picky, but on the Subquery placement option you have the following code:SELECT *
FROM ( SELECT staffId
FROM personnel )
CROSS JOIN (...
Problem with case expression in SELECT clause
When I use Lay Out SQL onselect value, case
when datediff(yyyy, p.TransactionDate, getdate()) = 0 then sum(p.Amount)
...
Quoted Identifiers
When I format:
SELECT *
FROM bob --a table I have created
It expands to:SELECT [bob].[bobId], [bob].[value]
FROM bob --a table I have created
With the ...
Non highlighted text is being syntax checked:
The following is the batch:
Check this out:
select *
from bob --a table I have created
select *
from bob
I highlight only one of the select * from bob and the following error is raised:
Documen...
CTP Expired Message
I uninstalled the previous version, installed the new version, restarted SSMS, went over the options (which look pretty nice, I might add) and then clicked "Lay Out SQL". This is the message:
SQL ...
extra linefeed/carriage return characters
Need to remove extra linefeed/carriage return characters. Often a script comes from Outlook or the newsgroups with extra lines like:
SELECT column
FROM table
WHERE a=b
AND c=d
And this is rea...
Must become less intrusive
I think that the problem I am having with the tool in general is when I am not using it, it becomes a real annoyance, and none of the activation keys can be used in normal coding.
The window poppin...