|
|
Browse by Tags
All Tags » IsNumeric
-
An interesting issue was found by a colleague of mine: an exception when cast a nvarchar column to integer even if the column value was checked with IsNumeric on SQL 2000 SP4:select c.IDfrom dbo.COM_COMPANY c where IsNumeric(c.CODE) = 1 and convert(c.CODE as int) = 304 and DELETED = 0As result the following exception were raised:Msg 245, Level 16, ...
|
|
|