macros.ini

是一个delphi的流程制作软件

[INSTRUCTIONS]
This macro list is intended to be customizble by each individual user.
1. Create a new header in the next consecutive order: MACRO1..MACROn.
2. Add a NAME line to name the macro.
3. Add a DESCR line to describe the macro.
4. Add TEXT1..TEXTn lines to enter the macro lines.
NOTE: if you need to show a blank line, enter a tilda (~) to reserve it.

[MACRO1]
NAME=Comment Block
DESCR=Standard Procedure Comment Block
TEXT1=/*  */

[MACRO2]
NAME=Select Block
DESCR=Standard Select-From Block
TEXT1=SELECT * 
TEXT2=FROM <tabName>
TEXT3=WHERE <field> = <@field>

[MACRO3]
NAME=Insert Block
DESCR=Standard Insert-Into Block
TEXT1=INSERT INTO <tabName>
TEXT2=(
TEXT3=<field list>
TEXT4=)
TEXT5=VALUES
TEXT6=(
TEXT7=<@field list>
TEXT8=)

[MACRO4]
NAME=Update Block
DESCR=Standard Update Block
TEXT1=UPDATE <tabName>
TEXT2=SET
TEXT3=<field> = <@field>
TEXT4=WHERE <field> = <@field>

[MACRO5]
NAME=Delete Block
DESCR=Standard Delete Block
TEXT1=DELETE FROM <tabName>
TEXT2=WHERE <field> = <@field>

[MACRO6]
NAME=Create Procedure
DESCR=Create Procedure Template
TEXT1=CREATE PROCEDURE <sp_procedure name$get>
TEXT2=(
TEXT3=<parameters>
TEXT4=)
TEXT5=AS
TEXT6=---------------------------------------------------------------------------------------------------------------
TEXT7=-- Description
TEXT8=--  Create Procedure Template
TEXT9=--
TEXT10=-- Implementation Notes
TEXT11=--
TEXT12=-- Results Sets
TEXT13=--   none
TEXT14=--
TEXT15=-- Returns
TEXT16=--   0 if successful, -1 to -99 for system errors
TEXT17=--   -100 record could not be inserted
TEXT18=--
TEXT19=-- Modification Log
TEXT20=--
TEXT21=-- Name   Date            Modification
TEXT22=-- ------ --------------  ----------------------------
TEXT23=-- PERSON	01/01/00	Whatever you did.
TEXT24=---------------------------------------------------------------------------------------------------------------
TEXT25=~
TEXT26=--Turns off the message returned at the end of each
TEXT27=--statement that states how many rows were affected
TEXT28=set nocount on
TEXT29=~
TEXT30=--this is the value that will be returned in return
TEXT31=declare @returnVal int
TEXT32=select @returnVal = 0
TEXT33=~
TEXT34=--If debug mode , maintain log
TEXT35=if object_id("tempdb..#debug") is not null
TEXT36=  execute sp__audit "<Your comment here>", "starting"
TEXT37=~
TEXT38=<SQL code here>
TEXT39=~
TEXT40=--  If debug mode , maintain log
TEXT41=if object_id("tempdb..#debug") is not null
TEXT42= execute sp__audit "<Your comment here>", "finishing"
TEXT43=~
TEXT44=RETURN @returnVal

[MACRO7]
NAME=Insert Procedure
DESCR=Insert Procedure Template
TEXT1=CREATE PROCEDURE <sp_procedure name$ins>
TEXT2=(
TEXT3=<parameters>
TEXT4=)
TEXT5=AS
TEXT6=---------------------------------------------------------------------------------------------------------------
TEXT7=-- Description
TEXT8=--  Insert Procedure Template
TEXT9=--
TEXT10=-- Implementation Notes
TEXT11=--
TEXT12=-- Results Sets
TEXT13=--   none
TEXT14=--
TEXT15=-- Returns
TEXT16=--   0 if successful, -1 to -99 for system errors
TEXT17=--   -100 record could not be inserted
TEXT18=--
TEXT19=-- Modification Log
TEXT20=--
TEXT21=-- Name   Date            Modification
TEXT22=-- ------ --------------  ----------------------------
TEXT23=-- PERSON	01/01/00	Whatever you did.
TEXT24=---------------------------------------------------------------------------------------------------------------
TEXT25=~
TEXT26=--Turns off the message returned at the end of each
TEXT27=--statement that states how many rows were affected
TEXT28=set nocount on
TEXT29=~
TEXT30=--this is the value that will be returned in return
TEXT31=declare @returnVal int
TEXT32=select @returnVal = 0
TEXT33=~
TEXT34=--If debug mode , maintain log
TEXT35=if object_id("tempdb..#debug") is not null
TEXT36=  execute sp__audit "<Your comment here>", "starting"
TEXT37=~
TEXT38=<SQL code here>
TEXT39=~
TEXT40=--  If debug mode , maintain log
TEXT41=if object_id("tempdb..#debug") is not null
TEXT42= execute sp__audit "<Your comment here>", "finishing"
TEXT43=~
TEXT44=RETURN @returnVal

[MACRO8]
NAME=Update Procedure
DESCR=Update Procedure Template
TEXT1=CREATE PROCEDURE <sp_procedure name$upd>
TEXT2=(
TEXT3=<parameters>
TEXT4=)
TEXT5=AS
TEXT6=---------------------------------------------------------------------------------------------------------------
TEXT7=-- Description
TEXT8=--  Update Procedure Template
TEXT9=--
TEXT10=-- Implementation Notes
TEXT11=--
TEXT12=-- Results Sets
TEXT13=--   none
TEXT14=--
TEXT15=-- Returns
TEXT16=--   0 if successful, -1 to -99 for system errors
TEXT17=--   -100 record could not be inserted
TEXT18=--
TEXT19=-- Modification Log
TEXT20=--
TEXT21=-- Name   Date            Modification
TEXT22=-- ------ --------------  ----------------------------
TEXT23=-- PERSON	01/01/00	Whatever you did.
TEXT24=---------------------------------------------------------------------------------------------------------------
TEXT25=~
TEXT26=--Turns off the message returned at the end of each
TEXT27=--statement that states how many rows were affected
TEXT28=set nocount on
TEXT29=~
TEXT30=--this is the value that will be returned in return
TEXT31=declare @returnVal int
TEXT32=select @returnVal = 0
TEXT33=~
TEXT34=--If debug mode , maintain log
TEXT35=if object_id("tempdb..#debug") is not null
TEXT36=  execute sp__audit "<Your comment here>", "starting"
TEXT37=~
TEXT38=<SQL code here>
TEXT39=~
TEXT40=--  If debug mode , maintain log
TEXT41=if object_id("tempdb..#debug") is not null
TEXT42= execute sp__audit "<Your comment here>", "finishing"
TEXT43=~
TEXT44=RETURN @returnVal

[MACRO9]
NAME=Delete Procedure
DESCR=Delete Procedure Template
TEXT1=CREATE PROCEDURE <sp_procedure name$del>
TEXT2=(
TEXT3=<parameters>
TEXT4=)
TEXT5=AS
TEXT6=---------------------------------------------------------------------------------------------------------------
TEXT7=-- Description
TEXT8=--  Delete Procedure Template
TEXT9=--
TEXT10=-- Implementation Notes
TEXT11=--
TEXT12=-- Results Sets
TEXT13=--   none
TEXT14=--
TEXT15=-- Returns
TEXT16=--   0 if successful, -1 to -99 for system errors
TEXT17=--   -100 record could not be inserted
TEXT18=--
TEXT19=-- Modification Log
TEXT20=--
TEXT21=-- Name   Date            Modification
TEXT22=-- ------ --------------  ----------------------------
TEXT23=-- PERSON	01/01/00	Whatever you did.
TEXT24=---------------------------------------------------------------------------------------------------------------
TEXT25=~
TEXT26=--Turns off the message returned at the end of each
TEXT27=--statement that states how many rows were affected
TEXT28=set nocount on
TEXT29=~
TEXT30=--this is the value that will be returned in return
TEXT31=declare @returnVal int
TEXT32=select @returnVal = 0
TEXT33=~
TEXT34=--If debug mode , maintain log
TEXT35=if object_id("tempdb..#debug") is not null
TEXT36=  execute sp__audit "<Your comment here>", "starting"
TEXT37=~
TEXT38=<SQL code here>
TEXT39=~
TEXT40=--  If debug mode , maintain log
TEXT41=if object_id("tempdb..#debug") is not null
TEXT42= execute sp__audit "<Your comment here>", "finishing"
TEXT43=~
TEXT44=RETURN @returnVal