[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