Wednesday, October 24, 2012

Changing the datatype of a Column in Sql server

Want to change the datatype of a field from Varchar to integer in T-SQL? The syntax for MS SQL is: ALTER TABLE table ALTER COLUMN column_name new_data_type Ex. ALTER TABLE MyTable ALTER COLUMN MyColumn NVARCHAR(20)