Running SQL Files
From SQLBWiki
[edit] Running SQL Files
- You can either open an existing SQL file or create a new file to type SQL statements. Example
- Each window has its own connection, which is opened on first SQL run
- Each window has its own connection, which is opened on first SQL run
- Right Click in the window opens a menu which allows to change the connection state:
- You can separate batches to be sent by using the classical go separator on its own line
- You send SQL code by pressing the "Run SQL" button or by hitting F10
- You can send only a portion of SQL by selecting a block of text first
[edit] Selecting Rows in the Result Window
There are 3 selection 'modes':
- Row Selection
- Column Selection
- Free Selection
You switch between these modes by:
- Simple Click - selects either the row, column or cell depending on the mode (Ctrl/Shift to add to selection)
- Double Click - switch to 'row selection' mode and selects the row
- Triple Click - switch to 'column selection' mode and selects the column
- Click and Drag - switch to 'free selection' mode and selects the block
