How to create table using select query in SQL Server?

by 
select <column list> into <table name> from <source> where <whereclause>

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. Conditional WHERE clause in SQL Server
  5. How can I select the first day of a month in SQL?
  6. Multi-statement Table Valued Function vs Inline Table Valued Function
  7. SQL Server Insert if not exists
  8. GROUP BY to combine/concat a column [duplicate]
  9. Select statement to find duplicates on certain fields
  10. Copy data into another table
  11. Using a Variable in OPENROWSET Query
  12. How to find current transaction level?
  13. How do I see active SQL Server connections?
  14. EXISTS vs JOIN and use of EXISTS clause
  15. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  16. Why is a UDF so much slower than a subquery?
  17. Split function in SQL Server 2008
  18. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  19. Remove numbers from string sql server
  20. Alternate of lead lag function in SQL Server 2008
  21. UNIX_TIMESTAMP in SQL Server
  22. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  23. SQL Server SELECT LAST N Rows
  24. How can I group by date time column without taking time into consideration
  25. The transaction log for the database is full
  26. Generate random int value from 3 to 6
  27. Add emoji / emoticon to SQL Server table
  28. How to execute a stored procedure inside a select query
  29. Using CASE Statement inside IN Clause
  30. SQL Unpivot multiple columns Data

Leave a Comment