How to create a table from select query result in SQL Server 2008 [duplicate]

by

Use following syntax to create new table from old table in SQL server 2008

Select * into new_table  from  old_table

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  3. sql server 2008 management studio not checking the syntax of my query
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. Querying data by joining two tables in two database on different servers
  6. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  7. Real life example, when to use OUTER / CROSS APPLY in SQL
  8. Where value in column containing comma delimited values
  9. How to find all connected subgraphs of an undirected graph
  10. How to use table variable in a dynamic sql statement?
  11. SQL query to split column data into rows
  12. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  13. SQL Server 2008: how do I grant privileges to a username?
  14. Create Trigger to log SQL that affected table?
  15. Transfer data from one database to another database
  16. How to find third or nᵗʰ maximum salary from salary table?
  17. SQL “between” not inclusive
  18. Can I set ignore_dup_key on for a primary key?
  19. Selecting first row per group
  20. Using PIVOT in SQL Server 2008
  21. sql varchar(max) vs varchar(fix)
  22. How do I prevent a database trigger from recursing?
  23. sql group by only rows which are in sequence
  24. Function in SQL Server 2008 similar to GREATEST in mysql?
  25. Convert Date format into DD/MMM/YYYY format in SQL Server
  26. Converting Select results into Insert script – SQL Server
  27. How to retrieve field names from temporary table (SQL Server 2008)
  28. When using GETDATE() in many places, is it better to use a variable?
  29. How to execute a stored procedure inside a select query
  30. Using CASE Statement inside IN Clause

Leave a Comment