convert a coloumn datatype ntext to varchar

  • How to convert a coloumn datatype ntext to varchar .

    The table have around 1 lack rows.

  • Best would be to create a new table and copy the data but you can do it by adding a new column, updating to copy the data then dropping the old column and renaming the new.


    Cursors never.
    DTS - only when needed and never to control.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply