December 30, 2008 at 10:17 am
i mistakenly created a column on a table with a very small size. now i want to increase the size of that column. any idea?
thanks!
December 30, 2008 at 10:30 am
ibnzakariyyahh (12/30/2008)
i mistakenly created a column on a table with a very small size. now i want to increase the size of that column. any idea?thanks!
create table #t
(col1 nvarchar(100)
)
alter table #t alter column col1 varchar(200)
December 30, 2008 at 11:35 am
hi, please cud u show a specific example. cos i used the statement u gave, but it doesn't work. thanks.
December 30, 2008 at 12:35 pm
Change it in the Management Studio Table Designer. It will take care of everything.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 31, 2008 at 2:10 am
i got the stuff rait. thanks to u all.
av a blessed day.
December 31, 2008 at 8:29 am
Glad we could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply