Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Create SQL insert statement with data from DB

Author  Topic 

Niels Peter Frandsen
Starting Member

2 Posts

Posted - 2004-10-18 : 07:51:37
Hi...
I want to create a SQL statement from an existing table in a MS SQL Server DB with query and data included - not just the metadata. The idea is to execute the SQL statement (including all data) from a JDBC connection. Can SQL Server manager do that? - and how?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-18 : 16:33:58
Could you post an example of what you mean?

Tara
Go to Top of Page

Henrik Svensson
Starting Member

25 Posts

Posted - 2004-10-19 : 03:27:44
Could this help you:

http://vyaskn.tripod.com/code.htm#inserts

?

With best regards,
Henrik Svensson
Go to Top of Page

Niels Peter Frandsen
Starting Member

2 Posts

Posted - 2004-10-19 : 05:13:48
Well, Just what I needed....! Thankyou

quote:
Originally posted by Henrik Svensson

Could this help you:

http://vyaskn.tripod.com/code.htm#inserts

?

With best regards,
Henrik Svensson

Go to Top of Page
   

- Advertisement -