What do you do when you have over 863 seriously advanced stored procedures you need to update as soon as possible?
I don’t know about you but here is what I would do. I would download Redgate’s SQL Refactor.
Working with legacy SQL code means untangling someone else's coding format and quickly interpreting the purpose of the script. SQL Refactor provides a range of one-click features that instantly make legacy code as easy to work with as your own, including Layout SQL, Summarize Script, Encapsulate as a New Stored Procedure, and many more.
 | Update all dependant objects when you rename tables, views, and procedures Expand wildcards and qualifying object names to improve quality and performance Summarize complex SQL scripts 11 refactorings in total Smart column rename for views and tables Smart parameter rename for procedures and functions Split Table, can also create referential integrity tables Uppercase Keywords Summarize Script Expand Wildcards in SELECT statements Qualify Object Names Find Unused Variables and Parameters Encapsulate As New Stored Procedure Smart Rename, for objects |
