Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Convert varchar to text

Posted on 1998-10-13
3
Medium Priority
?
553 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
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

580 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