Comments
Sort by recent activity
Hi Allen,
I have followed your suggestion and changed <IgnoreSquareBrackets> to false, checked the change in and then set it back to true and checked in again without success. SSMS was also restarted between comparisons.
I set the option by right-clicking the repository name in the Setup tab and selecting "Edit Comparison Options..." - I assume this is the correct place to change it.
Do you have any other suggestions I can try? / comments
Hi Allen,
I have followed your suggestion and changed <IgnoreSquareBrackets> to false, checked the change in and then set it back to true and checked in again without success. SSMS was also restart...
Hi Aaron,
SELECT * FROM Dept d INNER JOIN Employee e ON d.DeptId = e.DeptId
reformats to SELECT
*
FROM
Dept d
INNER JOIN Employee e ON d.DeptId = e.DeptId
whereas
SELECT * FROM Dept d JOIN Employee e ON d.DeptId = e.DeptId
reformats to SELECT
*
FROM
Dept d
JOIN
Employee e ON d.DeptId = e.DeptId
My preference is for the latter, but I can't find an option to set this
Thanks
Andy / comments
Hi Aaron,
SELECT * FROM Dept d INNER JOIN Employee e ON d.DeptId = e.DeptId
reformats toSELECT
*
FROM
Dept d
INNER JOIN Employee e ON d.DeptId = e.DeptId
whereas
SELECT * FROM Dept d JOIN E...