SQLMaker is a framework that can output T-SQL through variant replace and statement short circuit.
1. Run the \HelloWorld\HelloWorld.exe;
2. Copy sql statments below to the left edit box of HelloWorld window;
{BeginDate=2013-01-01}
{pid=1,2,3}
SELECT *
FROM billdetail b
WHERE ('{BeginDate}'='' or billdate>='{BeginDate}')
#ifdef pid
and ptypeid in ({pid})
#endif
4. If you are lucy to see the transformed sql statements showed in the right edit box, it means SQLMaker is ready for you.
We encourage you to contribute to SQLMaker!
Join us!