how to change datatype bit to int in sql server 2008

Question

0.00/5 (No votes)

See more:

SQL-Server

Posted 23-May-12 3:03am

DINESH K MAURYA

Updated 15-Jun-12 2:50am

Tim Corey

v2

Add a Solution

Comments

Prasad_Kulkarni 23-May-12 9:06am

20008???

Wendelius 23-May-12 14:47pm

That's going to be released a few years from now, just a bit after Mr Gates is defrosted from cryo chamber :)

Tim Corey 15-Jun-12 8:50am

Could you please accept one or more of the answers below so that this question is closed out? Thanks.

5 solutions

Solution 1

There is a data type called 'tiny int' in sql server which is equivalent to bit or byte.. You could use Cast or Convert function in TSQL to convert the value to int or small int etc

Please refer the link below

http://msdn.microsoft.com/en-us/library/ms187928.aspx

If you want to Alter the table itself converting from byte to Int will not have any problems as you are adding more bytes to the same value.. Only from int to bit will be a problem (values will be truncated)..

Posted 23-May-12 3:10am

Jim Jos

Updated 23-May-12 3:19am

v2

Solution 3

SQL

Try:
ALTER TABLE table_name ALTER COLUMN column_name INT

Other option is to create new column of type INT, populate this field with existing BIT column & drop old column once you are done.

This will be safe in case you want to see the data before you actually drop the original column..

Posted 23-May-12 3:12am

Om Prakash Pant

Solution 5

Try to this

ALTER TableName ALTER COLUMN ColumnName INT

Posted 15-Jun-12 3:57am

Yatin chauhan

Solution 4

check out this article to alter table.

http://www.gigasters.com/post.aspx?postid=18[^]

Posted 15-Jun-12 2:39am

Milind Karpe

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad_Kulkarni · Accepted Answer · 2012-05-23T03:11:00

Solution 2

You can easily do this using the following command.

SQL

ALTER TABLE dbo.YourTable ALTER COLUMN YourColumnName INT

Posted 23-May-12 3:11am

Prasad_Kulkarni

Updated 23-May-12 9:06am

v2

Comments

Wendelius 23-May-12 15:06pm

Good answer, just corrected a small typo :)

Prasad_Kulkarni 23-May-12 23:49pm

Thank you :)