I need to change datatypes of multiple columns within multiple tables. How can I do this? Is there any stored procedure that will allow me to change on sys.types table?
Thanks.
I need to change datatypes of multiple columns within multiple tables. How can I do this? Is there any stored procedure that will allow me to change on sys.types table?
Thanks.
There's no Swiss Army Knife for this sort of thing. General approach:
Do it all outside of business hours.
Thank you.