Insert and Select Statement

• monilps

  SSCommitted

  Points: 1686

  More actions

  January 29, 2013 at 9:07 am

  #273525

  Hi,

  I want to generate script that will have insert statement and select statement for each table in a database.

  For Example:

  insert into tableA (idA, columnA)

  select idA, columnA from tableA

  insert into tableB (idB, columnB)

  select idB, columnB from tableB

  etc...

  Thanks.

• Sean Lange

  SSC Guru

  Points: 286609

  More actions

  January 29, 2013 at 10:30 am

  #1582257

  monilps (1/29/2013)

  ---

  Hi,

  I want to generate script that will have insert statement and select statement for each table in a database.

  For Example:

  insert into tableA (idA, columnA)

  select idA, columnA from tableA

  insert into tableB (idB, columnB)

  select idB, columnB from tableB

  etc...

  Thanks.

  Are you wanting to duplicate all of the data in every table? If you can explain what you are trying to do more clearly we can help.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/