top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How to change multiple column datatype in SQL Server single query.

+6 votes
303 views
How to change multiple column datatype in SQL Server single query.
posted Apr 1, 2015 by Khusboo

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Try something like

ALTER TABLE table_name
  MODIFY (column_1 column_type,
      column_2 column_type,
      ...
      column_n column_type);
answer Apr 1, 2015 by Salil Agrawal
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...