Please help me to explain this sample query.please.... email me daumentze@yahoo.com
begin tran --rollback --commit
delete from tbl_autosys_info where configuration like 'INT-355%'
delete from tbl_autosys_info where configuration like 'INT-356%'
delete from tbl_autosys_info where configuration like 'INT-357%'
delete from tbl_autosys_info where configuration like 'HRPEO-I0115%'
--10rows
delete from [db_IntegrationAnalytics].[dbo].[tbl_AutoBuildRef_Connections] where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].[dbo].[tbl_AutoBuildRef_Connections] where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].[dbo].[tbl_AutoBuildRef_Connections] where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].[dbo].[tbl_AutoBuildRef_Connections] where interfaceid like 'HRPEO-I0115%'
--0 rows
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_fieldinterface where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_fieldinterface where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_fieldinterface where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_fieldinterface where interfaceid like 'HRPEO-I0115%'
--(42 row(s) affected)
delete from tbl_fields where sourceapp ='20156ACA-EEF0-4A76-AFAA-5F9F95FE02F2'
--(42 row(s) affected)
delete from [db_IntegrationAnalytics].[dbo].[tbl_InterfaceNotifications] where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].[dbo].[tbl_InterfaceNotifications] where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].[dbo].[tbl_InterfaceNotifications] where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].[dbo].[tbl_InterfaceNotifications] where interfaceid like 'HRPEO-I0115%'
--6 rows
delete from db_ebiconfiguration_node1.dbo.[ssis configurations] where configurationfilter like 'INT-355%'
delete from db_ebiconfiguration_node1.dbo.[ssis configurations] where configurationfilter like 'INT-356%'
delete from db_ebiconfiguration_node1.dbo.[ssis configurations] where configurationfilter like 'INT-357%'
delete from db_ebiconfiguration_node1.dbo.[ssis configurations] where configurationfilter like 'HRPEO-I0115%'
--148 rows
delete from db_ebiconfiguration_node2.dbo.[ssis configurations] where configurationfilter like 'INT-355%'
delete from db_ebiconfiguration_node2.dbo.[ssis configurations] where configurationfilter like 'INT-356%'
delete from db_ebiconfiguration_node2.dbo.[ssis configurations] where configurationfilter like 'INT-357%'
delete from db_ebiconfiguration_node2.dbo.[ssis configurations] where configurationfilter like 'HRPEO-I0115%'
--148 rows
delete from [db_IntegrationAnalytics].[dbo].tbl_Master_Events where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].[dbo].tbl_Master_Events where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].[dbo].tbl_Master_Events where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].[dbo].tbl_Master_Events where interfaceid like 'HRPEO-I0115%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_frequency where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_frequency where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_frequency where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_frequency where interfaceid like 'HRPEO-I0115%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfaceautosys where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfaceautosys where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfaceautosys where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfaceautosys where interfaceid like 'HRPEO-I0115%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfacecontact where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfacecontact where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfacecontact where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].[dbo].tbl_rel_interfacecontact where interfaceid like 'HRPEO-I0115%'
delete from tbl_interfaces where sourceapp ='20156ACA-EEF0-4A76-AFAA-5F9F95FE02F2'
or targetapp='20156ACA-EEF0-4A76-AFAA-5F9F95FE02F2'
--(6 row(s) affected)
delete from tbl_applications where applicationid in ('20156ACA-EEF0-4A76-AFAA-5F9F95FE02F2')
--(1 row(s) affected)
delete from [db_IntegrationAnalytics].dbo.tbl_SecureTransport_Configuration where interfaceid like 'INT-355%'
delete from [db_IntegrationAnalytics].dbo.tbl_SecureTransport_Configuration where interfaceid like 'INT-356%'
delete from [db_IntegrationAnalytics].dbo.tbl_SecureTransport_Configuration where interfaceid like 'INT-357%'
delete from [db_IntegrationAnalytics].dbo.tbl_SecureTransport_Configuration where interfaceid like 'HRPEO-I0115%'
--7 rows
--43 rows
--Total 446
|