can we 'alter table' in mssql?

[enterume]

In MySQL, there is a alter function for us to change the datatype.

How can I do this at MSSQL? and what is the outcome if i change the datatype? because i heard from someone say the data might be lost when changing the datatype? what's the limitation?

Thanks
Louis

[chriskl]

I suggest searching MSDN:

http://www.microsoft.com/msdn/

Chris