| Avinash Neelkant 2002-06-26, 6:25 am |
| If you need to create insert statements for the data
aready existing in database...
one of the options is export the table data into any of
destination formats like excel,csv using DTS.
Right click database in Enterprise Manager and go for All
Tasks/Export Data and the wizard will guide you.
When you want the data back....Use Import Data to get the
data back...Use appropriate options while importing to
either delete data and import or append to existing data.
Hope this solves your poblem.
>-----Original Message-----
>I need to generate the INSERT queries from my database in
order to populate
>it later.
>
>Is there any function that does it in sqlserver or any
tool that can do that
>?
>
>
>Thanx
>
>
>.
>
|