I have a table with 100 records. Now I want to generate INSERT statements with the same data. How will you generate?

Open SSMS — Right click on Database — Tasks — Generate scripts — Next — Select specific database objects — select your table — Next — Select the output type — Advanced — Select data only from Types of data to script property — Ok — Next — Next — Click on Finish after completion of execution.

Latest Comments
  1. laavanya

    hi chandra,
    very nice website,covered from very basics in Sql to high level.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.