Sanket Sirotiya Home
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)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)