Generating INSERT statements in SQL Server

• ikorenbl

  SSCommitted

  Points: 1750

  More actions

  October 22, 2004 at 8:06 am

  #59539

  Does anybody have code to generate SQL Insert statements that can be used, for example, for tranferring data from development to production.

  I found this code on the internet, but it doesn't handle the NULL values well.

  http://www.codeproject.com/database/InsertGeneratorPack.asp

  Thanks

• ikorenbl

  SSCommitted

  Points: 1750

  More actions

  October 22, 2004 at 8:11 am

  #527659

  I just found another link that seems to handle NULLs better. Can anyone validate that this is the right logic? Thanks again.

  http://www.dotnetspider.com/technology/KBPages/716.aspx

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  October 25, 2004 at 3:28 am

  #527781

  Why not use good old bcp, or even the DTS wizard can do this kind of stuff with a few clicks?

  /Kenneth

• Schalk van der Merwe

  SSC Veteran

  Points: 254

  More actions

  October 25, 2004 at 4:07 am

  #527783

  exactly what do you need? i checked out the two links and there's a lot of unneccesary stuff in there. can you give me an example? do you want exact output " INSERT INTO

  ( col1, col2 ) select * from "