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)"