SQL Server Plugin:sqlformatterssmsaddin

( recommended ) very useful SQL Server statement formatting tools.

Before formatting:

After formatting:

: Http://architectshack.com/PoorMansTSqlFormatter.ashx

The above provides a variety of forms to use, such as client mode, notepad++ plug-in and so on. I'm using the first SSMS and Visual Studio add-in, integrated into SQL Server. After installation, open SQL Server Management Studio, click "Tools" in the menu bar to see the shortcut: ctrl+k,ctrl+f

If you do not want to download the plugin, it also provides the Web page formatted SQL statement, the URL is: http://poorsql.com/

Copy your SQL statement into the "Input SQL" option, and Switch to "formatted SQL" to see the formatted statement.