[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Convert varchar to text

Posted on 1998-10-13
3
Medium Priority
?
552 Views
Last Modified: 2008-02-26
I need to convert a field from Varchar(255) to a Text field. How is that done in MSSQL 6.5 ?

(The table contains data)

Thanks for your help...
0
Comment
Question by:cisDK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:cisDK
ID: 1090531
Edited text of question
0
 
LVL 7

Accepted Solution

by:
Victor Spiridonov earned 400 total points
ID: 1090532
It can be done only in the following steps:
Rename old table
create new table with type changed
insert data into a new table
drop old table
There is no way in SQL server to change datatype in existing table.
0
 

Author Comment

by:cisDK
ID: 1090533
Ok, too bad... :/
0

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question