You can try out the free SSMS and VS add-in, ApexSQL Complete
ApexSQL Complete provides scanned and syntactic checks and many code autofill functions (contextual predictions of keywords, users, objects, autocomplete aliases, the parameter for automatically setting the parameters of the Insert procedure, the Insert full INSERT option, etc.)
For code refactoring, you can use ApexSQL Refactor , as well as a free add-on
Disclaimer: I work for ApexSQL as a support engineer
source share