Change DataType of column in SQL Server

Last Reply 3 months ago By AnkitPal

Posted 3 months ago

Dear Programer,

Please explain how to convert a column data type char to DateTime

You are viewing reply posted by: AnkitPal 3 months ago.
Posted 3 months ago

Well Efforts. But my requirment is another, and solved by self.

Thanks to efforst. Note - I was change my data table's data type of a specific column.

It could be happen if we are set column value as NULL than we are changed tha column data type very easy as - 

Step 1 -

alter table table_name
alter column column_name datatype null;

Step 2 - 

alter table table_name
alter column column_name datatype;
I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html