Hi,
I have a table with some data in it, I would like to
generate one Insert script command for each record.
Is there a SQL Server tools for doing it?
I mean, this is my table:
NamesTbl
Name Surname
-------------------------------------
Filippo Bettinaglio
John Gill
Nick .....
the script genereted should be:
INSERT INTO NamesTbl (Name, Surname) VALUES
('Filippo', 'Bettinaglio')
INSERT INTO NamesTbl (Name, Surname) VALUES
('John', 'Gill')
....
thanks,
Filippo
Adam Machanic - 18 Oct 2004 17:13 GMT
There's a script here to do that:
http://vyaskn.tripod.com/code.htm
> Hi,
>
[quoted text clipped - 22 lines]
> thanks,
> Filippo