probleum in changing the data type of column

[veer]

hello expert
can any one help me by providing the method how can i change the data type of column in sql server
originally my column data type is numeric and i want to change it into integer
i use the covert command but it is not changing the data type of column

please provide some help
thanks in advance

[vksingh24]

hello expert
can any one help me by providing the method how can i change the data type of column in sql server
originally my column data type is numeric and i want to change it into integer
i use the covert command but it is not changing the data type of column

please provide some help
thanks in advance

You can chage it this way

ALTER TABLE <TABLE_NAME> 
ALTER COLUMN <COLUMN_NAME> NUMERIC

[veer]

hello expert
it is not working
it is producing the syntax error near keyword alter

You can chage it this way

ALTER TABLE <TABLE_NAME> 
ALTER COLUMN <COLUMN_NAME> NUMERIC

[debasisdas]

Here is the complete syntax.

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

[veer]

HELLO EXPERT
PLEASE CONVERT THIS SYNTAX INTO EXAMPLE
MY TABLE NAME IS "OUTPUT"
MY COLUMN NAME IS "ENTRY"
COLUMN DATA TYPE IS NUMERIC


THANKS IN ADVANCE

Here is the complete syntax.

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

[debasisdas]

Try This

alter Table Output Alter Column Entry Numeric (5,2)