How to change datatype?

Question

How to change datatype?

anzz

SSCertifiable

Points: 5503
More actions
August 29, 2012 at 9:36 am

#266038

syntx for changing Varchar(225) NOT NULL column to Varchar(1000) NOT NULL

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

To a column? or to a variable?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 2

alter table MyTable alter column MyColumn varchar(1000) not null

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/