Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Dump table as I...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 10970 of 11262
Post > Topic >>

Dump table as INSERTs

by D.Stone@[EMAIL PROTECTED] Apr 16, 2008 at 08:00 AM

Is there an easy way to create a SQL script to re-create and re-
populate a table?
Both Enterprise Manager 8.0 and Management Studio Express 2005 will
generate the CREATE TABLE, but they only seem to produce a generic
INSERT statement with place-holders instead of values. Not ideal for
any table with more than 10 rows!

Cheers,

Dave
 




 2 Posts in Topic:
Dump table as INSERTs
D.Stone@[EMAIL PROTECTED]  2008-04-16 08:00:25 
Re: Dump table as INSERTs
Pasi Oja-Nisula <pon@[  2008-04-16 20:05:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 2:49:46 CDT 2008.