How to create table using select query in SQL Server?

Question

I try to make 50-100 tables using SYS queries

SELECT windows_release, windows_service_pack_level,         windows_sku, os_language_version FROM sys.dm_os_windows_info OPTION (RECOMPILE);     -- DEĞİŞİRSE INSERT ETSIN AYNI ISE DEĞİŞMESİN  -- Gives you major OS version, Service Pack, Edition, and language info for the operating system  -- SQL Server Services information (SQL Server 2008 R2 SP1 or greater) SELECT servicename, startup_type_desc, status_desc,  last_startup_time, service_account, is_clustered, cluster_nodename FROM sys.dm_server_services OPTION (RECOMPILE);   -- Hardware information from SQL Server 2008  -- (Cannot distinguish between HT and multi-core) SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio], cpu_count/hyperthread_ratio AS [Physical CPU Count],  physical_memory_in_bytes/1048576 AS [Physical Memory (MB)],  sqlserver_start_time --, affinity_type_desc -- (affinity_type_desc is only in 2008 R2) FROM sys.dm_os_sys_info OPTION (RECOMPILE); 

How to create table from SYS tables queries result?

Answer 1

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

Answer 2

select <column list> into <dest. table> from <source table>; 

You could do this way.

SELECT windows_release, windows_service_pack_level,         windows_sku, os_language_version into   new_table_name FROM   sys.dm_os_windows_info OPTION (RECOMPILE);