Generate insert script

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sjaak van Esdonk
    #1

    Generate insert script

    does anyone know if there is a way to generate an insert script based
    on the records in a table? I want to distribute the contents of a
    couple of tables to customers without having to use BCP or DTS.

    Greetings Sjaak
    Tags: None
    • Simon Hayes
      #2
      Re: Generate insert script


      "Sjaak van Esdonk" <sjaakvanesdonk @hotmail.com> wrote in message
      news:7479e65c.0 404050347.11056 49b@posting.goo gle.com...[color=blue]
      > does anyone know if there is a way to generate an insert script based
      > on the records in a table? I want to distribute the contents of a
      > couple of tables to customers without having to use BCP or DTS.
      >
      > Greetings Sjaak[/color]

      My code library (SQL Server T-SQL code samples, snippets, examples, tips, tricks, stored procedures, user defined functions, VB programs): Narayana Vyas Kondreddi's home page
      http://vyaskn.tripod.com/code.htm#inserts
      Welcome to the SQL Server website of Narayana Vyas Kondreddi. This site features a unique, one of a kind SQL Server replication FAQ, SQL Server T-SQL code samples, DBA and Database developer interview questions, Database object naming conventions, Database programming guidelines, Interesting articles and much more!

      http://www.rac4sql.net/objectscriptr_main.asp


      Simon


        Comment

        • Sjaak van Esdonk
          #3
          Re: Generate insert script

          Thanks Simon, thats exactly what i needed! This is going to save me lots of time !

            Comment

            • Thomas
              #4
              Re: Generate insert script

              sjaakvanesdonk@ hotmail.com (Sjaak van Esdonk) wrote in message news:<7479e65c. 0404050347.1105 649b@posting.go ogle.com>...[color=blue]
              > does anyone know if there is a way to generate an insert script based
              > on the records in a table? I want to distribute the contents of a
              > couple of tables to customers without having to use BCP or DTS.
              >
              > Greetings Sjaak[/color]


              Hi,
              use SQL Scripter (http://www.sqlscripter.com) to create Insert, Update
              or Delete scripts ...

              Thomas

                Comment

                Previous template Next
                Working...