Q:

SQL server - How to copy data in a column to other column

I have a table like
|name|
|a   |
....

name column has datatype is ntext I want to create a new column with other datatype text and it has same data with column name.
How to do that thanks

A:

You should use varchar(max) instead of text.  The following adds the column and sets the value:
alter table t add newcol varchar(max);

update t
    set newcol = name;

