<div>
BIGINT is there in sql server 2005.<br />
<br />
REFER for more - <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql" rel="ugc">https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql</a>
</div>


BIGINT is there in sql server 2005.

REFER for more - https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql [https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql]

<div>
Hi Pawan<br />
<br />
If I have to convert a field from integer to bigint, I can have any kind of problem?
</div>


Hi Pawan

If I have to convert a field from integer to bigint, I can have any kind of problem?

<div>
you can do that ..<br />
<br />
col1 is of type INT.<br />
<br />
CAST( col1 AS BIGINT )
</div>


you can do that ..

col1 is of type INT.

CAST( col1 AS BIGINT )

<div>
When I told you &nbsp;&quot; convert &quot;&nbsp;I mean to change the extruture of my field from int to bigint, the table
</div>


When I told you  " convert " I mean to change the extruture of my field from int to bigint, the table

<div>
Thanks a lot Pawan for your help
</div>


<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
I need to use the big int and I am not sure what version of mssql has the kind of field. <br />
<br />
I use the mssql 2008 but I am not sure if in mssql 2005 there is this field bigInt.<br />
<br />
Could you help me on this?<br />
<br />
Thanks
</div>
</div>


Hello, 

I need to use the big int and I am not sure what version of mssql has the kind of field. 

I use the mssql 2008 but I am not sure if in mssql 2005 there is this field bigInt.

Could you help me on this?

Thanks

Where can I get the difference among fields type in mssql versions?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.