Aug
25
2010
Notepad++ scripts to remember
#SHOW CONSOLE – RUN THIS AT NOTEPAD++ STARTUP
NPP_CONSOLE ON
CLS
#SQL EXECUTE SELECTED – SAVES SELECTED TEXT TO TEMP FILE AND RUN IN SQL
NPE_CONSOLE v+
$(NPP_DIRECTORY)\GETDATETIME.BAT
SET TEMP_FILE= $(SYS.TEMP)\$(OUTPUTL)
NPE_CONSOLE v+
SEL_SAVETO $(TEMP_FILE) :a
CLS
SQLCMD -S.\SQLExpress -E -i"$(TEMP_FILE)"
#SQL EXECUTE FILE – EXECUTES THE WHOLE SCRIPT IN SQL
#YOU COULD USE INPUTBOX TO GET THE DATABASE NAME
cls
SQLCMD.EXE -E -S.\SqlExpress -i "$(FULL_CURRENT_PATH)" -deScore
#OPEN EXPLORER – OPEN THE EXPLORER WINDOW FOR THE CURRENT FILE
NPP_RUN EXPLORER "$(CURRENT_DIRECTORY)"
[...] Yesterday I posted a couple of Notepad++ scripts. One of them referenced a GetDateTime.bat file. For that Notepad++ script to work that batch file has to be in the Notepad++ root folder. [...]