A small free .Net and JS library (with demo UI, command-line bulk formatter, SSMS/VS add-in, notepad++ plugin, winmerge plugin, and demo webpage) for reformatting and coloring T-SQL code to the user's preferences.
select * from TABLE_NAME_A A inner join TABLE_NAME_B B on A.COLUMN = B.COLUMM left join TABLE_NAME_C C on A.COLUMN = C.COLUMN
where C.COLUMN is not null.
The following keywords are uppercased, INNER, JOIN, NULL. Other keywords I have seen upper cased are UNION, UNION ALL. There might be more but this is all I have documented from my query work.
the mimify has no option for case conversion so I would expect it to leave code alone.
If I mimify this statement.
select * from TABLE_NAME_A A inner join TABLE_NAME_B B on A.COLUMN = B.COLUMM left join TABLE_NAME_C C on A.COLUMN = C.COLUMN where C.COLUMN is not null.
The following keywords are uppercased, INNER, JOIN, NULL. Other keywords I have seen upper cased are UNION, UNION ALL. There might be more but this is all I have documented from my query work.
the mimify has no option for case conversion so I would expect it to leave code alone.