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
There's a script here to do that:
http://vyaskn.tripod.com/code.htm
"Filippo Bettinaglio" <anonymous@.discussions.microsoft.com> wrote in message
news:0c6501c4b510$8fcda620$a501280a@.phx.gbl...
> 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
>
No comments:
Post a Comment