how we change one data type into another in sql

[veer]

hello expert
can any one help me by providing the way how we can change a column data type from one into another
e,g i have a column which have datatype numeric and i want to change it into Integer
thanks in advance

[Jim Doherty]

hello expert
can any one help me by providing the way how we can change a column data type from one into another
e,g i have a column which have datatype numeric and i want to change it into Integer
thanks in advance

Look at the CAST and CONVERT functions and reference them in your SQL

typically :

SELECT CONVERT (int,YourNumericfieldname) as MyIntegerField FROM YourTableName

Regards

Jim :)

[veer]

hello expert
i am not understanding your query , is it right syntax
SELECT CONVERT (int,entry) as record FROM output
where entry is the numeric column name and record is the new column name
please check it and correct
thanks

Look at the CAST and CONVERT functions and reference them in your SQL

typically :

SELECT CONVERT (int,YourNumericfieldname) as MyIntegerField FROM YourTableName

Regards

Jim :)

[amitpatel66]

hello expert
i am not understanding your query , is it right syntax
SELECT CONVERT (int,entry) as record FROM output
where entry is the numeric column name and record is the new column name
please check it and correct
thanks

You can just try out and check if it works isint it?
Post back if it throws any error

[veer]

it shows the syntax error near "as " keyword
and when i use another command
"select convert(int, entry) from output"
it execute but not conver the numeric data type to integer

You can just try out and check if it works isint it?
Post back if it throws any error

[amitpatel66]

it shows the syntax error near "as " keyword
and when i use another command
"select convert(int, entry) from output"
it execute but not conver the numeric data type to integer

Why dont you try this one:

ALTER TABLE table1 MODIFY (entry INT);
 
 

But before running above query, you need to empty the table and then run alter command. so take a backup of the data,run the above alter command and reload the data

[veer]

shows the syntax error on modify
is there any probleum with version of sql because i am using sql server 2000

Why dont you try this one:

ALTER TABLE table1 MODIFY (entry INT);
 
 

But before running above query, you need to empty the table and then run alter command. so take a backup of the data,run the above alter command and reload the data

[amitpatel66]

shows the syntax error on modify
is there any probleum with version of sql because i am using sql server 2000

Tryh this:

 
ALTER TABLE <table>
{ [ ALTER COLUMN <column_name>
  { <new_data_type> [ ( <precision> [ , <scale> ] ) ]