up

1. Build select SQL script
2. Build insert SQL script
3. Build update SQL script
4. Build delete SQL script

1. Build select SQL script

DtSQL provides a tool to help users to build select SQL script

• Click 'Build SQL' menu to pop up the SQL builder panel
• Select 'Select' tab to build select SQL
• Select 'Table' tab and add tables used in the select SQL script

• Select 'Column' tab and add selected columns

• Select 'Condition' tab and add where condition in the SQL script

• Select 'Group By' tab and add group columns

• Select 'Having' tab and add having condition in the SQL script

• Select 'Order By' tab and add sorted columns in the SQL script

• Select 'SQL' to show the built select SQL script

• Click 'Execute' button to execute SQL script
  

2. Build insert SQL script

DtSQL provides a tool to help users to build insert SQL script

• Click 'Build SQL' menu to pop up the SQL builder panel
• Select 'Insert' tab to build insert SQL
• Select the 'Table' tab and add tables used in the insert SQL script

• Select the 'Value' tab and set the column value

• Select the 'SQL' tab to show the bult insert SQL script

• Click 'Execute' button to execute insert SQL script

3. Build update SQL script

DtSQL provides a tool to help users to build update SQL script

• Click 'Build SQL' menu to pop up the SQL builder panel
• Select 'Update' tab to build update SQL
• Select the 'Table' tab and add tables used in the update SQL script

• Select the 'Value' tab and set the new column value

• Select 'Condition' tab and add where condition in the update SQL script

• Select the 'SQL' tab to show the bult update SQL script

• Click 'Execute' button to execute update SQL script

4. Build delete SQL script

DtSQL provides a tool to help users to build update SQL script

• Click 'Build SQL' menu to pop up the SQL builder panel
• Select 'Delete' tab to build delete SQL
• Select the 'Table' tab and add tables used in the delete SQL script

• Select 'Condition' tab and add where condition in the delete SQL script

• Select the 'SQL' tab to show the bult delete SQL script

• Click 'Execute' button to execute delete SQL script