change datatype of all parameters with same name
neilx
Posts: 14
How could I change the parameter datatype automatically in dozens of stored procedures to reflect a new datatype. E.g.:
@LanguageCode nvarchar(2) should be changed everywhere to
@LanguageCode varchar(6)
@LanguageCode nvarchar(2) should be changed everywhere to
@LanguageCode varchar(6)
Comments
Unfortunately SQL Refactor will not help you in this scenario. I do not known of another Red Gate product that will help you. Sorry.
Many Thanks
Eddie
Eddie Davis
Product Support Engineer
Red Gate Software Ltd
e-mail: support@red-gate.com
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com