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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

getting sql scripts out of sql 2005

Status
Not open for further replies.

bouwob

Programmer
Apr 12, 2006
171
0
0
US
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
 
Use a SELECT instruction with some JOIN clauses.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top