Solved

varchar to text

Posted on 2010-09-07
4
359 Views
Last Modified: 2012-05-10
alter datatype
varchar to text
0
Comment
Question by:rgb192
4 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 33622333
If you are using SQL 2005, why would you want to do that?  You are better off using varchar(max) than text...
0
 
LVL 19

Accepted Solution

by:
Bhavesh Shah earned 500 total points
ID: 33624625
alter table <<tableName>>
alter column <<ColumnName>> varchar(max)
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33625594
create table testtbl (vc varchar(1000))
GO
alter table testtbl alter column vc text
GO
0
 

Author Closing Comment

by:rgb192
ID: 33628392
thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
OPENDATASOURCE 8 36
Two tables - Sum of values - What is the difference 31 48
How to import SQL 2000 database to SQL 2014 5 99
Query 14 54
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now