Post reply

convert a coloumn datatype ntext to varchar

  • December 11, 2012 at 1:04 am

    #271407

    How to convert a coloumn datatype ntext to varchar .

    The table have around 1 lack rows.

  • December 11, 2012 at 1:25 am

    #1567277

    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