Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Generate Insert,Update... script

Status
Not open for further replies.

Kristjan

Programmer
Nov 12, 2002
29
CR
I know DTS and how use it, but I need to generate the script code for a Table X, like MySQL exports...
Example: MyTable has (col1,col2,col3)
select * FROM MyTable
:
col1 col2 col3
---- ---- ----
a1 b1 c1
a2 b2 c2
a3 b3 c3

SQLServer has something to export this like Insert, etc
INSERT MyTable VALUES('a1',b1,'c1')
INSERT MyTable VALUES('a2',b2,'c2')
INSERT MyTable VALUES('a3',b3,'c3')

also UPDATE,DELETE etc...
and how export that to .txt or .sql

ok, export as plain text is avaible or DTS but i need the script code...

tnx
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top