valores - ¿Cómo crear una tabla usando la consulta de selección en SQL Server?

order by sql server ejemplos

Question

Intento hacer 50-100 tablas usando consultas SYS

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);

¿Cómo crear una tabla a partir de consultas de tablas SYS?

Answer 1

Sé que es una vieja pregunta, pero encontré algo así y está funcionando perfectamente:

 CREATE TABLE resultTable AS(SELECT gdb.song AS vroar,
gdb.song_description AS vdescription FROM googleDB gdb WHERE
gdb.song_id = ''KP'');

sintaxis:

CREATE TABLE <ResultTable_Name> AS(SELECT <actual_table_property1> AS <alias1>, <actual_table_property2> AS <alias2>
FROM <actual_table_name> WHERE <actual_table_property> = ''<value>'');

Espero que esto ayude a alguien.

Answer 2

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

Podrías hacerlo de esta manera.

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

Answer 3

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