TSQL Script to generate SQL scripts of data in a table? 
Author Message
 TSQL Script to generate SQL scripts of data in a table?

Hi
I am looking for a TSQL script that will generate SQL scripts (the
same as the Generate SQL scripts in EM does) which contain all the
data from a set table.  You know how when you are working with a test
app in a book you usualy get two SQL script files, one will create the
tables, and then the other has all the data which is entered into the
tables once created.  So, I am looking for tips on, location of etc a
TSQL script that would pasre through a table or query and get all the
data from the table and write it (obviously as INSERT lines) line by
line into an SQL file.

Any ideas (I hope I made sense of what I am after)

TIA for any help you can offer

Richard



Sun, 23 May 2004 01:09:42 GMT
 TSQL Script to generate SQL scripts of data in a table?

Richard,

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

Dinesh.



Quote:
> Hi
> I am looking for a TSQL script that will generate SQL scripts (the
> same as the Generate SQL scripts in EM does) which contain all the
> data from a set table.  You know how when you are working with a test
> app in a book you usualy get two SQL script files, one will create the
> tables, and then the other has all the data which is entered into the
> tables once created.  So, I am looking for tips on, location of etc a
> TSQL script that would pasre through a table or query and get all the
> data from the table and write it (obviously as INSERT lines) line by
> line into an SQL file.

> Any ideas (I hope I made sense of what I am after)

> TIA for any help you can offer

> Richard



Sun, 23 May 2004 01:14:24 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Generate MS-ACCESS table using SQL Script generated by SQL Server

2. Generate SQL Script for data of SQL Server table

3. Generate SQL Script for data of SQL Server table

4. Generate SQL Script for all objects in a database programmatically using TSQL

5. SQL Script to generate SQL Scripts???

6. Most effective way to generate script for data in SQL table

7. Generate SQL script along with table data

8. System-Generated Change Script Losing Table's Data - SQL 2000

9. generate SQL scripts from a script or stored procedure

10. How can I script db from tsql script?

11. how to generate the script to create the tables with data

12. Generate Table script and insert data


 
Powered by phpBB® Forum Software