View Single Post
Old 2016-08-23, 16:41   #1111
If I May
chalsall's Avatar
"Chris Halsall"
Sep 2002

2·4,643 Posts

Originally Posted by Madpoo View Post
But even that means making sure any updates/inserts aren't using implicit column placements... I'm pretty sure anything like that is explicitly handled (as far as I've seen, that's the case) but Murphy's law says there'd be that one exception where an insert assumes columns are in a certain order and doesn't spell 'em out.
Implicit column placements... Shutter....

Your planned migration sounds sane. Add the new column at the end of the table and the worst case will be the new nvarchar column isn't updated by any legacy code doing implicit references.
chalsall is offline   Reply With Quote