GilaMonster (1/31/2012)
SQL Kiwi (1/31/2012)
GilaMonster (1/31/2012)
jcb (1/31/2012)
Can You rely on a trigger to safe truncate the data to the column?No, because types are checked before triggers fire.
Yes, if you use a view 😉 ...
True, but probably not an option in this case seeing as they're looking for a quick fix and locating all the places that it can happen for a fix isn't apparently allowed.
I have seen cases where the base table is renamed, as the view named as the base table...well you know the pattern. That said, my reply was intended for interest and completeness, rather than as a practical suggestion.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi