Convert bit column to integer

Question

I am converting bit columns of a particular table to integer through an SQL script (this table has some default constraints for default value).

I have to alter the columns for the table, not runtime casting, What script can be used to accomplish this?

Answer 1

Try using CAST(columnName AS INT) AS IntValue.

e.g.

SELECT columnName, CAST(columnName AS INT) AS IntValue FROM table 

OR you can use CONVERT(INT, columnName) AS IntValue.

UPDATE: If you need to alter the actual metadata of the table, then you first need to drop the constraints then alter the column:

i.e.

ALTER TABLE [Table] DROP CONSTRAINT [ConstraintName]; GO ALTER TABLE [Table] ALTER COLUMN [ColumnName] INT; 

Then recreate any constraints that you need.

Answer 2

If you are concerned about changing the datatype of the column you can use an ALTER query as follows.

ALTER TableName ALTER COLUMN ColumnName INT 

Else, only for display purposes, you can use either the CAST or CONVERT function:

CAST(columnName AS INT) AS IntegerVal CONVERT(int, columnName) AS IntValue