select
from (
) t
fails with:
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
Where 2147483647 is the max value of an int datatype.
Notes on Microsoft SQL Server 2005. Including SQL Server Integration Services (SSIS)
No comments:
Post a Comment