Not able to write multiline SQL query in SQL Management Studio

Dear Team,


I have developed a process to write a SQL queries in SQL and save the outputs in the excel.

In which there are some multiline queries which are not running after migration on another server, bot is writing multiline queries in long single line.

Please let us know if any settings or prerequisites that are needed for SQL Management Studio.

FYI, SQL Version is changed from 12.0 to 15.0 on another server.

Thanks & Regards,

Amol Golhar

Hello Amol
you can rewrite the sql query with View try
Thanks
Prem