Re: Generating insert/update statements from a resultset

This only generates INSERT statements from result sets - and only a SELECT can generate a result set.

Regards,
Daniel

Am 08.04.2026 um 16:26 schrieb Richard Schoen <richard@xxxxxxxxxxxxxxxxx>:

Will that work for insert/updates too ?



Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>



________________________________

message: 3
date: Wed, 8 Apr 2026 16:00:42 +0200
from: Daniel Gross <daniel@xxxxxxxx>
subject: Re: Generating insert/update statements from a resultset

In VS Code prefix the SELECT statement with "SQL:"

Example:

sql: select * from ...;

This should work.

HTH
Daniel

Am 08.04.2026 um 15:37 schrieb Richard Schoen <richard@xxxxxxxxxxxxxxxxx>:

?Hey, does anyone new if the VS Code plugin or another tool like DBeaver can generate insert statements from a resultset ?

Trying to gen some insert statements for testing.

Before I write a utility I wanted to see if I?m missing something.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.