How to format sql statement in notepad++

notepad How to format sql statements: First click the [Plug-in] option in the menu bar; then click the [Poor Man's T-Sql Formatter] and [Format T-SQL Code] options in sequence.

In the process of doing ETL, database optimization or operation and maintenance, we often face a large number of long strings of SQL statements, many of which are not typeset and readable. The performance is very poor and seems quite tiring. So how to automatically format these SQLs?

Open notepad, select "Plug-in"-"Plugin Manager"-"Show Plugin Manager" (recommended learning: notepad )

In "Plugin Manager", find the "Poor Man's T-Sql Formatter" plug-in and install it.

#After installing the plug-in, simply configure it. Simple explanation, you will know what it means after reading it! If you don’t understand, you can configure it and format it to see the effect!

Click format to see the effect

The effect after formatting.

The above is the detailed content of How to format sql statement in notepad++. For more information, please follow other related articles on the PHP Chinese website!