"frank" <frank@discussions.microsoft.com> wrote in message
news:10C047C2-79BA-4592-9E53-3E9DFEF296D5@microsoft.com:

> I am wondering if there is an easy way to script data into script.
>
> i.e. I want to create a script file. For each record in each table, I'll
> have a sql script like
>
> INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(1, 'myVal11', 'myval12')
> INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(2, 'myVal21', 'myval22')
> ...
>
> I know I can do it in Oracle but I could get it in SQL Server by
> scripting
> DB objects.
>
> Frank