Converting Select results into Insert script – SQL Server

by

Here is another method, which may be easier than installing plugins or external tools in some situations:

  • Do a select [whatever you need]INTO temp.table_namefrom [... etc ...].
  • Right-click on the database in the Object Explorer => Tasks => Generate Scripts
  • Select temp.table_name in the “Choose Objects” screen, click Next.
  • In the “Specify how scripts should be saved” screen:
    • Click Advanced, find the “Types of data to Script” property, select “Data only”, close the advanced properties.
    • Select “Save to new query window” (unless you have thousands of records).
  • Click Next, wait for the job to complete, observe the resulting INSERT statements appear in a new query window.
  • Use Find & Replace to change all [temp.table_name] to [your_table_name].
  • drop table [temp.table_name].

More Related Contents:

  1. sql server 2008 management studio not checking the syntax of my query
  2. SQL Server 2008: how do I grant privileges to a username?
  3. Unpivot with column name
  4. How can I delete using INNER JOIN with SQL Server?
  5. What this query does to create comma delimited list SQL Server?
  6. Convert varchar into datetime in SQL Server
  7. sql query to return differences between two tables
  8. Check if a row exists, otherwise insert
  9. How do I make a composite key with SQL Server Management Studio?
  10. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  11. How to write UPDATE SQL with Table alias in SQL Server 2008?
  12. SQL Server 2008- Get table constraints
  13. Restrict an SQL Server connection to a specific IP address
  14. Execute Dynamic Query with go in sql
  15. TransactSQL to run another TransactSQL script
  16. How can I get a list of element names from an XML value in SQL Server
  17. Why are logical reads for windowed aggregate functions so high?
  18. How to rename something in SQL Server that has square brackets in the name?
  19. Comma Separated values with SQL Query
  20. how to separate string into different columns?
  21. Using IF ELSE statement based on Count to execute different Insert statements
  22. SQL Server SELECT INTO @variable?
  23. How do I change db schema to dbo
  24. How to subtract 30 days from the current date using SQL Server
  25. Count records for every month in a year
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment