Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

convert a coloumn datatype ntext to varchar Expand / Collapse
Author
Message
Posted Tuesday, December 11, 2012 1:04 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 3:15 AM
Points: 412, Visits: 1,015
How to convert a coloumn datatype ntext to varchar .
The table have around 1 lack rows.
Post #1394922
Posted Tuesday, December 11, 2012 1:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 13, 2013 4:35 AM
Points: 386, Visits: 211
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.
Post #1394929
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse