Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select cmd = 'alter table [' + c.table_schema + '].[' + c.table_name + '] alter column [' + c.column_name + '] nvarchar',* from information_schema.columns c where c.data_type='varchar' order by CHARACTER_MAXIMUM_LENGTH desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement