getting sql scripts out of sql 2005

[bouwob]

I have 3 tables that I need to pull sql for. I only need the data, not the table structures or rights.

How do I get this information from only 3 tables and export it to a .sql file?


tia

 

[PHV]

Use a SELECT instruction with some JOIN clauses.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bouwob]

I do not need a list of data.

I need a file that looks something like this

insert into table (a,b,c) values ('a',2,'c');
insert into table (a,b,c) values ('b',2,'c');
insert into table (a,b,c) values ('c',2,'c');
insert into table (a,b,c) values ('d',2,'c');
insert into table (a,b,c) values ('e',2,'c');
insert into table1 (a,b) values ('a',2);
insert into table1 (a,b) values ('b',2);
insert into table1 (a,b) values ('c',2);
insert into table1 (a,b) values ('d',2);
insert into table1 (a,b) values ('e',2);

etc

 

[r937]

this is the ANSI SQL forum

you'd be better off asking your question in forum183

those guys will know of a tool that can produce the required output

r937.com | rudy.ca