1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
Create Insert Statements
Within the Schema Browser|Tables|Data Grid, you can create an INSERT statement that encompasses all rows in the data grid, or just selected rows.
To create INSERT statements for selected rows
Right-click over the data grid and make sure that Multi-select is checked.
In the data grid, select the rows for which you want insert statements.
Right-click and select Create INSERT for selected rows. The Data Export window appears. Make any changes to the settings and click OK.
By default, insert statements are copied to the clipboard and you then can paste them within the Editor for editing or running. However, click the options tab and you can specify a destination.
To create INSERT statements for all rows
Right-click over the data grid and make sure that Allow Multi-select is unchecked.
Right-click over the data grid and select Create INSERT for all rows. The Data Export window appears. Make any changes to the settings and click OK.
By default, insert statements are copied to the clipboard and you then can paste them within the Editor for editing or running. However, click the options tab and you can specify a destination. |
Partager