Int field type and error messages.. 
Author Message
 Int field type and error messages..
Hi all,

I'm sure someone can answer this one with the greatest of ease...

Typically I've known an 'int' type to have an upper value of 32 thousand
something, and the same as a negative value...

With SQL Server it seems higher...thing is I've been testing stuff and
exceeded it, so I'd like to know what the highest number is...

This :



Fri, 06 Jan 2006 20:15:12 GMT
 Int field type and error messages..

Damn that control-B combo!!!!

As I was saying...

This :

pageid=9999999999

for example produces this error message

Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar
value '9999999999' overflowed an int column. Maximum integer value exceeded.

Stick another 9 on the end (pageid=99999999999), and

Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.

is produced

This however is ok...

pageid=999999999

clearly exceeding the 32 thousand thing...

can anyone tell me what the highest number is please?

Cheers

Robb



Fri, 06 Jan 2006 20:17:30 GMT
 Int field type and error messages..
Books online is a wonderous thing!


Fri, 06 Jan 2006 20:23:40 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Syntax error converting the varchar value to a column of data type int

2. Error converting data type varchar to int

3. Arithmetic overflow error converting expression to data type int

4. Error converting data type int to smalldatetime

5. Checking for type-conversion errors (char to int)

6. select Year from Int where Int.Year >= p_From and Int.Year <= p_To

7. big text field -> message type 0x44

8. To add a field of the type Dates with a field of the Whole type

9. Concatenating datetime field and int field to make a date time

10. VB error message of unrecognized data type

11. How to display only ORA type error messages when running a script

12. Error -408 Invalid message type


 
Powered by phpBB® Forum Software