The answer is definitely wrong!
I ran the exact same query on SQL Server 2008 R2 & I got the same error everyone got:
Msg 8152, Level 16, State 14, Line 3
String or binary data would be truncated.
The statement has been terminated.
(0 row(s) affected)
How come parameter
and you insert 11 char value?!
Of course the insert statement will fail!
I want my point back ;-)