[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;
or:
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