NppExec [sourceforge] allows you to execute commands and scripts from a console window in Notepad++. It can be found in the menu bar at
Plugins -> NppExec or just by simply hitting the F6 key (the shortcut Ctrl+F6 will run the latest command) .
Example: the following will
output_var: on, meaning we can use the output of the console
NPE_CONSOLE v+ sqlcmd -S 188.8.131.52 -U UserName -P "password" -i C:\scripts\query.sql sel_settext $(OUTPUT) NPP_CONSOLE 0 cls
NppExec also allows you to save your scripts. After saving them, you can go to
Plugins -> NppExec -> Advanced Options and run it anytime Notepad++ starts, closes, or even add that script to the Plugin commands using Macros. For example, by saving the above example as a "Run Query", I could use the bottom left fields in the Advanced Options to add it to the menu.
The script will be available as a macro after a restart of Notepad++ as long as the "Place to the Macros submenu" box is checked.
Finally, a shortcut can be assigned to the macro/command by using
Settings -> Shortcut mapper -> Plugin commands.