vbnetcoder
asked on
create insert script based on records in a table
how do i create an insert script for the records currently in a table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just for the record, to have the INSERT commands in a script, right-click on the database name, choose Tasks / Generate Scripts... then specify the table or tables that you want and then click in the Advanced button and scroll down until the option "Types of data to script" and change it to "Data only" (default is Schema only).
ASKER
thank you!
ASKER