Activity overview
Latest activity by Arcom
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...
IgnoreSquareBrackets Option Not Working
Hi,
I have the IgnoreSquareBrackets option set to true however, square brackets which have been removed from a stored proc are still being identified as a change when compared to the currently depl...
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...
Formatting after JOIN
When using SQL Prompt > Format SQL when using the JOIN statement the table name and join condition are indented and placed on the next line (which is my preference).
If I user an INNER JOIN, LEFT J...