SQLTeam.com | Weblogs | Forums

Widening Columns


#1

It's a familiar problem... The business requests a column of say size 50 characters. A few years later they need that to fit more information and ask the column to become say size 100 characters. So, we make the column 100, easy. Now, we need to modify say 30 Stored Procedures. Because all the temp tables, variables and parameters relating to that column also need to be changed from 50 to 100.

Just wondered how others deal with this?

I was wondering about implementing a policy: whatever the business asks for, we multiply it by 5.


#2

I think you just have to change it. There's really no way to anticipate this or prepare for it.

If you do truly expect it to change, you could use a user-defined-data-type for that column, but that has other issues/concerns of its own.