Solved

Convert varchar to text

Posted on 1998-10-13
3
537 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:
spiridonov earned 100 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL 10 35
LTrim & Double Space Correction 5 40
SQL server 2014 replication error 20 41
Run Stored Procedure uisng ADO 5 21
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

829 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