[thelist] SQL Server Export As Query?

Matt Warden mwarden at gmail.com
Wed Aug 4 10:56:25 CDT 2004

On Wed, 4 Aug 2004 09:54:38 -0500 , Rob Smith <rob.smith at thermon.com> wrote:
> Hi
> Does anyone know how to export a table in SQL Server 2k as a insert query?

Is this what you mean?

SELECT foo, bar INTO othertable FROM sourcetable;


INSERT INTO othertable (foo, bar)
SELECT foo, bar FROM sourcetable;


Matt Warden
Berry Neuroscience Lab
Department of Psychology
Miami University

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list