Home Forums Article Discussions Article Discussions by Author Discuss content posted by Oleg Netchaev Generating Insert Statements RE: Generating Insert Statements

  • July 1, 2009 at 7:01 am

    #1018345

    Chris Howarth (7/1/2009)

    Nice idea.

    An alternative is to use SSMS 2008's in-built data scripting functionality:

    http://www.sqlskills.com/BLOGS/PAUL/post/Scripting-schema-AND-data-with-SSMS-in-SQL-2008.aspx

    Chris

    I just love it when I start the day off learning something new. With this link, and with the article showing how to do the inserts as binary data, I've learned two things.

    Great article, and good link here ... I didn't know that this was in SSMS2008.

    Edit: quoted wrong message when posting.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2