How to set SQL keywords to automatically capitalize 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 them are not formatted and have poor readability. They look quite tiring. So how can we automatically format them? What about these SQLs?

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

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 [Plug-ins] - [Poor Man's T-Sql Formatter] - [Format T-SQL Code] in the notepad menu bar

sql keywords will be automatically capitalized

The above is the detailed content of How to set SQL keywords to automatically capitalize in notepad. For more information, please follow other related articles on the PHP Chinese website!