Home  >  Article  >  Development Tools  >  How to format sql statement in notepad++

How to format sql statement in notepad++

(*-*)浩
(*-*)浩Original
2019-08-10 11:30:3025715browse

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.

How to format sql statement in notepad++

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 )

How to format sql statement in notepad++

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

How to format sql statement in notepad++

#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

How to format sql statement in notepad++

The effect after formatting.

How to format sql statement in notepad++

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn