dump a single record as sql?

Is it possible to dump a single record (or the results of select stmt) as a
SQL cmd?

For example, I do one-time entries on my dev server to test a new db entry.
Then once I've got the entry right, I want to dump that record as an insert
stmt I can copy to my prd server.

(sorry for the double-post, sent the msg too soon)

thx
a