Home All Groups Group Topic Archive Search About
Author
20 Oct 2005 10:39 PM
Adam Knight
Hi all,

I am needing to export the data contained in my database as series of sql
insert statements?

How do i do this in SQL Server?

Cheers,
Adam

Author
20 Oct 2005 10:44 PM
Jerry Spivey
Adam,

Try:

http://vyaskn.tripod.com/code/generate_inserts.txt

HTH

Jerry
Show quote
"Adam Knight" <a***@pertrain.com.au> wrote in message
news:%235ktmcc1FHA.664@tk2msftngp13.phx.gbl...
> Hi all,
>
> I am needing to export the data contained in my database as series of sql
> insert statements?
>
> How do i do this in SQL Server?
>
> Cheers,
> Adam
>
>
>
Author
21 Oct 2005 7:20 AM
Tibor Karaszi
.... and some other options: http://www.karaszi.com/SQLServer/info_generate_script.asp

Show quote
"Jerry Spivey" <jspi***@vestas-awt.com> wrote in message
news:%23N80Pfc1FHA.268@TK2MSFTNGP09.phx.gbl...
> Adam,
>
> Try:
>
> http://vyaskn.tripod.com/code/generate_inserts.txt
>
> HTH
>
> Jerry
> "Adam Knight" <a***@pertrain.com.au> wrote in message
> news:%235ktmcc1FHA.664@tk2msftngp13.phx.gbl...
>> Hi all,
>>
>> I am needing to export the data contained in my database as series of sql insert statements?
>>
>> How do i do this in SQL Server?
>>
>> Cheers,
>> Adam
>>
>>
>>
>
>

AddThis Social Bookmark Button