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
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