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)
No comments:
Post a Comment
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment