SLTechnology News&Howtos › Database ›

How to insert the queried data into the new table by Sqlserver

Shulou Source: shulou.com Published: 2022-06-01 07:21:32 10月03日 Update

First, create a new table:

Then use SQL to implement the query data insert into the new table:

Insert into test.dbo.tmp_tj001 (server_principal_name,object_name,maxdate)

Select s1.serverillustralplayname as maxdate from s1.objectplayname as maxdate from

(SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_920000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_520000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_450000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_650000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_980000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_730000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_430000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_670000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_380000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U') S1

Group by s1.server_principal_name,s1.object_name

Tags: Data query innovation Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi Shulou Information Redmi Huawei Shulou Technology