TOP
FORMAT SQL
[Advanced Setting]
[SQL Statement]
------------------------------------------------------- -- SQL FORMAT SAMPLE ------------------------------------------------------- select ISNULL(T1.ID,0) /* Staff Code */, T2.NAME1 , -- 1st Name T2.NAME2 /* 2n dName */ FROM TABLE1 T1, TABLE2 T2 WHERE (T1.ID = T2.ID AND T1.ID BETWEEN (100) AND 200) AND T2.NAME IS NOT NULL;
<setting> <delimiter> <item value=" " /> <item value="(" /> <item value=")" /> <item value="," /> <item value="=" /> <item value="+" /> <item value="-" /> <item value="<" /> <item value="<=" /> <item value=">" /> <item value=">=" /> <item value="<>" /> <item value="*" /> <item value="/" /> <item value="%" /> </delimiter> <upperLiteral> <item value="SELECT" /> <item value="UPDATE" /> <item value="DELETE" /> <item value="INSERT" /> <item value="WHEN" /> <item value="SET" /> <item value="THEN" /> <item value="FROM" /> <item value="WHERE" /> <item value="INNER" /> <item value="OUTER" /> <item value="JOIN" /> <item value="AS" /> <item value="ON" /> <item value="UNION" /> <item value="ALL" /> <item value="AND" /> <item value="OR" /> <item value="GROUP" /> <item value="ORDER" /> <item value="BY" /> <item value="ASC" /> <item value="DESC" /> </upperLiteral> <grouping> <item start="(" end=")" offset="1" /> <item start="CASE" end="END" offset="5" /> <item start="BEGIN" end="END" offset="1" /> <item start="BETWEEN" end="AND" offset="1" /> </grouping> <alignment> <item trigger="," reference="SELECT" logicPos="any" commaPos="left" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="," reference="FROM" logicPos="any" commaPos="left" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="," reference="SET" logicPos="any" commaPos="left" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="," reference="BY" logicPos="any" commaPos="left" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="," reference="(" logicPos="any" commaPos="left" ifbr="true" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="," reference="(" logicPos="any" commaPos="left" ifbr="true" procTarPos="refer" procTarOffset="1" procPos="pre" procName="shift" procArg="1" /> <item trigger="," reference="SELECT" logicPos="any" commaPos="right" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="," reference="FROM" logicPos="any" commaPos="right" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="," reference="SET" logicPos="any" commaPos="right" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="," reference="BY" logicPos="any" commaPos="right" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="," reference="(" logicPos="any" commaPos="right" ifbr="true" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="," reference="(" logicPos="any" commaPos="right" ifbr="true" procTarPos="refer" procTarOffset="1" procPos="pre" procName="shift" procArg="1" /> <item trigger="OR" reference="WHERE" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="OR" reference="ON" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="OR" reference="WHEN" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignEnd" procArg="2" /> <item trigger="OR" reference="WHEN" logicPos="left" commaPos="any" ifbr="any" procTarPos="refer" procTarOffset="1" procPos="pre" procName="shift" procArg="5" /> <item trigger="OR" reference="(" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignEnd" procArg="2" /> <item trigger="OR" reference="(" logicPos="left" commaPos="any" ifbr="any" procTarPos="refer" procTarOffset="1" procPos="pre" procName="shift" procArg="5" /> <item trigger="AND" reference="WHERE" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="AND" reference="ON" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="AND" reference="WHEN" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignEnd" procArg="1" /> <item trigger="AND" reference="WHEN" logicPos="left" commaPos="any" ifbr="any" procTarPos="refer" procTarOffset="1" procPos="pre" procName="shift" procArg="5" /> <item trigger="AND" reference="(" logicPos="left" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignEnd" procArg="1" /> <item trigger="AND" reference="(" logicPos="left" commaPos="any" ifbr="any" procTarPos="refer" procTarOffset="1" procPos="pre" procName="shift" procArg="5" /> <item trigger="OR" reference="WHERE" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="OR" reference="ON" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="OR" reference="WHEN" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="OR" reference="(" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="AND" reference="WHERE" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="AND" reference="ON" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="AND" reference="WHEN" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="AND" reference="(" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="post" procName="alignEnd" procArg="1" /> <item trigger="AND" reference="BETWEEN" logicPos="right" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="shift" procArg="1" /> <item trigger=")" reference="(" logicPos="any" commaPos="any" ifbr="true" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="FROM" reference="SELECT" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="FROM" reference="SET" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="END" reference="CASE" logicPos="any" commaPos="any" ifbr="true" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="ELSE" reference="WHEN" logicPos="any" commaPos="any" ifbr="true" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="WHEN" reference="WHEN" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="SET" reference="UPDATE" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="ON" reference="LEFT" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="ON" reference="RIGHT" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="ON" reference="INNER" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="UNION" reference="SELECT" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="SELECT" reference="_group_" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignEnd" procArg="0" /> <item trigger="LEFT" reference="FROM" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="INNER" reference="FROM" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="RIGHT" reference="FROM" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="CROSS" reference="FROM" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="LEFT" reference="UPDATE" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="INNER" reference="UPDATE" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="RIGHT" reference="UPDATE" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="CROSS" reference="UPDATE" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="WHERE" reference="FROM" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="WHERE" reference="SELECT" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="WHERE" reference="UPDATE" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="WHERE" reference="DELETE" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignEnd" procArg="0" /> <item trigger="GROUP" reference="FROM" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="ORDER" reference="FROM" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> <item trigger="ORDER" reference="PARTITION" logicPos="any" commaPos="any" ifbr="any" procTarPos="this" procTarOffset="0" procPos="pre" procName="alignRight" procArg="" /> </alignment> </setting>