Universal Database Tools - DtSQL Logo
  Site Map
 
   
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL navigator box   Home Universal Database Tools - DtSQL navigator box   Features Universal Database Tools - DtSQL  navigator box   Download Universal Database Tools - DtSQL  navigator box   Purchase Universal Database Tools - DtSQL  navigator box   Support Universal Database Tools - DtSQL  navigator box   Contact Universal Database Tools - DtSQL  navigator box   Events
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
     
 

SQL Builder

 
 

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
top
 

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
top
 

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
top
 

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
top

Copyright DigerTech Inc