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 ...