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

Answer 1

Try something like

ALTER TABLE table_name
  MODIFY (column_1 column_type,
      column_2 column_type,
      ...
      column_n column_type);