[This topic is migrated from our old forums. The original author name has been removed]
Isn't it possible to create insert statements for some data in a table? I thought that selecting the data and right clicking with the mouse and selecting "Script: Insert into table" would do this, but it just creates a strange sql....
I have marked 50 rows, shouldn't I get 50 insert statements with data?
BTJ
a
anonymous
said
over 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Creating insert statements for data in a table?
You can create insert statements for a data grid by choosing export. In the wizard that shows up you can choose for the SQL option. This will export your grid into a fill containing the insert statements.
Benny
a
anonymous
said
over 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Creating insert statements for data in a table?
Yes, I know...
But what is the feature I am talking about used for? (and if this feature should work as I think, then it is much faster than using Export..)
BTJ
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: Creating insert statements for data in a table?
BTJ,
The Script: features are used to create templates in the SQL Commander that you then need to edit/fill with actual data.
Regards
Roger
a
anonymous
said
over 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Creating insert statements for data in a table?
Hmmm..... That explains it...
But shouldn't there be a feature like the one I am talking about? It would make life a bit easier... :)
BTJ
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: Creating insert statements for data in a table?
BTJ,
I will add your request to make "Script: INSERT COPY INTO TABLE" multi row aware and the result will then be one INSERT per selected row.
Thanks!
Regards
Roger
anonymous
I thought that selecting the data and right clicking with the mouse and selecting "Script: Insert into table" would do this, but it just creates a strange sql....
Regards,
BTJ