![]() ![]() Once again, you can save the NppExec script, and make it show up in the Macro menu. If you want to do something more fancy, use the NppExec plugin, which includes a better batch/scripting language. If instead of running, you hit “SAVE”, you can give it a name (which will end up later in the Run menu), and/or a keyboard shortcut, so that you can easily re-use that many times. It will open a new cmd.exe Windows command prompt, and show the output from that file. If you just run it, that probably won’t show you any results… but if you ran cmd /k c:\path\to\sqlclient.exe $(FILE_NAME) For example, if your SQL client has a command-line mode accessed thru sqlclient.exe, you could type c:\path\to\sqlclient.exe $(FILE_NAME) If you have an existing somethingElse.sql file, you can open it in Notepad++, which will auto-recognize that it’s SQL and apply the syntax highlighting, allowing you to edit it and save it.īy using the Run > Run dialog, you can run an arbitrary command. If you save the file as something.sql, and then load something.sql in your SQL client, the client will run the SQL commands from that file. You will see color, bold, and other possible formatting applied to the text you type. SELECT * FROM mydatabase WHERE id LIKE 'ID%' After selecting the Language > SQL, Notepad++ will highlight SQL syntax as you type. Notepad++ is a text editor, so you can now use it to edit your SQL file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |