Posted by amish on 01/24/06 11:45

I think its because
Bigint takes 8 bytes storage and Int takes 4 bytes.
SQL Server will not automatically promote other integer data types
(tinyint, smallint, and int) to bigint.

Regards
Amish Shah

• Next in forum: Re: Conditional Column Name On Insert
• Prev in forum: Re: Question about converting bigint field to int field
• Thread view: Re: Question about converting bigint field to int field

[Reply to this message]