Bhuvnesh (10/8/2013)
jasona.work (10/7/2013)
Somehow a value of '16923951 0' got entered...while you insert value ( '16923951 0' ) into it.
it will throw error like "String , binary data would be truncated"
That's a 10-character string, it'll insert without error into a varchar(10).
It won't convert to numeric, but that will only be done when someone queries the calculated column, not at insert time, so the insert will succeed but subsequent selects will fail.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability