How Can I Create SQL Server Tables Directly from SYS Query Results?

Creating Tables from SYS Query Results in SQL Server

The provided SYS queries can provide valuable system information like operating system details, SQL Server service status, and hardware data. To create tables from the results of these queries, you can use the following syntax:

SELECT <column list> INTO <table name> FROM <source> WHERE <where clause>

For example, to create a table named "WindowsInfo" with the columns from the first query, you would use:

SELECT windows_release, windows_service_pack_level, windows_sku, os_language_version 
INTO WindowsInfo 
FROM sys.dm_os_windows_info OPTION (RECOMPILE);

Similarly, to create a table named "ServerServices" with the columns from the second query, you would use:

SELECT servicename, startup_type_desc, status_desc, last_startup_time, service_account, is_clustered, cluster_nodename 
INTO ServerServices
FROM sys.dm_server_services OPTION (RECOMPILE);

Finally, to create a table named "SystemInfo" with the columns from the third query, you would use:

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
INTO SystemInfo 
FROM sys.dm_os_sys_info OPTION (RECOMPILE);

By using the INTO clause, you can create tables directly from the results of your SYS queries, providing an easy and efficient way to store and analyze system information for further use.

The above is the detailed content of How Can I Create SQL Server Tables Directly from SYS Query Results?. For more information, please follow other related articles on the PHP Chinese website!