Solved

NEWBIE: TSQL to increase width of column?

Posted on 2006-10-31
3
500 Views
Last Modified: 2008-02-26
Dear Experts,

How do I increase the width of an existing field using TSQL?

Thanks,
BrianMc1958
0
Comment
Question by:BrianMc1958
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
ID: 17841854
alter table yourtable alter yourcolumn varchar(newsize)
0
 
LVL 14

Assisted Solution

by:mherchl
mherchl earned 25 total points
ID: 17841877
ALTER TABLE yourtable ALTER COLUMN yourcolumn varchar(newsize)
0
 

Author Comment

by:BrianMc1958
ID: 17841896
Thanks, folks.
--BrianMc1958
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 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

11 Experts available now in Live!

Get 1:1 Help Now