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

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
LVL 1
hidrauAsked:
Who is Participating?
 
Pawan KumarDatabase ExpertCommented:
0
 
Pawan KumarDatabase ExpertCommented:
0
 
hidrauAuthor Commented:
Hi Pawan

If I have to convert a field from integer to bigint, I can have any kind of problem?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Pawan KumarDatabase ExpertCommented:
you can do that ..

col1 is of type INT.

CAST( col1 AS BIGINT )
0
 
hidrauAuthor Commented:
When I told you  " convert " I mean to change the extruture of my field from int to bigint, the table
0
 
Pawan KumarDatabase ExpertCommented:
Please use this-

ALTER TABLE yourtableName
   ALTER COLUMN yourcolumName BIGINT
0
 
hidrauAuthor Commented:
Thanks a lot Pawan for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.