Link to home
Start Free TrialLog in
Avatar of rgb192
rgb192Flag for United States of America

asked on

convert datatype to varcharmax

table1.column1 datatype is text
what are benefits of using varcharmax

how to convert column1 to varcharmax
ASKER CERTIFIED SOLUTION
Avatar of vdr1620
vdr1620
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rgb192

ASKER

varchar(max) and text

which is quicker
varchar(max)
You can not run indexes against ntext
Avatar of rgb192

ASKER

thanks