code generation - What is the best way to auto-generate INSERT statements for a SQL Server table? -

-

we writing new application, , while testing, need bunch of dummy data. i've added data using ms access dump excel files relevant tables.

every often, want "refresh" relevant tables, means dropping them all, re-creating them, , running saved ms access append query.

the first part (dropping & re-creating) easy sql script, last part makes me cringe. want single setup script has bunch of inserts regenerate dummy data.

i have data in tables now. best way automatically generate big list of insert statements dataset?

i'm thinking of in toad (for oracle) can right-click on grid , click save as->insert statements, , dump big sql script wherever want.

the way can think of doing save table excel sheet , write excel formula create insert every row, surely not best way.

i'm using 2008 management studio connect sql server 2005 database.

microsoft should advertise functionality of ssms 2008. feature looking built generate script utility, functionality turned off default , must enabled when scripting table.

this quick run through generate insert statements of data in table, using no scripts or add-ins sql management studio 2008:

  1. right-click on database , go tasks > generate scripts.
  2. select tables (or objects) want generate script against.
  3. go set scripting options tab , click on advanced button.
  4. in general category, go type of data script
  5. there 3 options: schema only, data only, , schema , data. select appropriate option , click on ok.

you create table statement , of insert statements data straight out of ssms.


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more