BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'arc_file_link' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('arc_file_link') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'arc_file_link' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy arc_file_link: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'arc_record' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('arc_record') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'arc_record' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy arc_record: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11115' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11115') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11115' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11115: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11122' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11122') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11122' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11122: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11123' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11123') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11123' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11123: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11124' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11124') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11124' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11124: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11125' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11125') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11125' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11125: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11126' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11126') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11126' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11126: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11127' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11127') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11127' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11127: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11128' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11128') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11128' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11128: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11129' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11129') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11129' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11129: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_11130' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_11130') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_11130' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_11130: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_1265853' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_1265853') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_1265853' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_1265853: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_1265854' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_1265854') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_1265854' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_1265854: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_14941' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_14941') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_14941' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_14941: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_14942' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_14942') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_14942' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_14942: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_56971' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_56971') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_56971' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_56971: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_DATA_INFO' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_DATA_INFO') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_DATA_INFO' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_DATA_INFO: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_SYNC' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_SYNC') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_SYNC' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_SYNC: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'DY_SYNC_TO_DELETE' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('DY_SYNC_TO_DELETE') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DY_SYNC_TO_DELETE' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy DY_SYNC_TO_DELETE: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'dy_synchro_request' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('dy_synchro_request') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dy_synchro_request' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy dy_synchro_request: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ed_upload_sync' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ed_upload_sync') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ed_upload_sync' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ed_upload_sync: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'etmf_placeholder_generation_status' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('etmf_placeholder_generation_status') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'etmf_placeholder_generation_status' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy etmf_placeholder_generation_status: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'etmf_planning_template' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('etmf_planning_template') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'etmf_planning_template' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy etmf_planning_template: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'etmf_planning_template_artifact' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('etmf_planning_template_artifact') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'etmf_planning_template_artifact' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy etmf_planning_template_artifact: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'id_factory' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('id_factory') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'id_factory' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy id_factory: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'jdo_sequence' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('jdo_sequence') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'jdo_sequence' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy jdo_sequence: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_2xauth_action' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_2xauth_action') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_2xauth_action' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_2xauth_action: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_act_sub_process' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_act_sub_process') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_act_sub_process' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_act_sub_process: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_activity' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_activity') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_activity' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_activity: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_activity_form' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_activity_form') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_activity_form' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_activity_form: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_activity_templates' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_activity_templates') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_activity_templates' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_activity_templates: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_admin_group' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_admin_group') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_admin_group' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_admin_group: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_admin_persons' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_admin_persons') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_admin_persons' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_admin_persons: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_annotation_link' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_annotation_link') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_annotation_link' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_annotation_link: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_archived_role_person' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_archived_role_person') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_archived_role_person' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_archived_role_person: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_async_task' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_async_task') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_async_task' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_async_task: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_async_task_impacted_docs' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_async_task_impacted_docs') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_async_task_impacted_docs' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_async_task_impacted_docs: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_attachment' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_attachment') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_attachment' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_attachment: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_attachment_backup_extension' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_attachment_backup_extension') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_attachment_backup_extension' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_attachment_backup_extension: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_attachment_extension' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_attachment_extension') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_attachment_extension' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_attachment_extension: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_branch' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_branch') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_branch' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_branch: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_business_table' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_business_table') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_business_table' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_business_table: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_cc_job_searches' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_cc_job_searches') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_cc_job_searches' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_cc_job_searches: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_cc_transition' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_cc_transition') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_cc_transition' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_cc_transition: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_codification_rule' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_codification_rule') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_codification_rule' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_codification_rule: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_comment_childrens' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_comment_childrens') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_comment_childrens' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_comment_childrens: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_comment_recipients' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_comment_recipients') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_comment_recipients' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_comment_recipients: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_computed_docflow' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_computed_docflow') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_computed_docflow' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_computed_docflow: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_conf_level' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_conf_level') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_conf_level' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_conf_level: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_content' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_content') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_content' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_content: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_controlled_change' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_controlled_change') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_controlled_change' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_controlled_change: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_crossed_objects_search' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_crossed_objects_search') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_crossed_objects_search' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_crossed_objects_search: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_def_rec_group' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_def_rec_group') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_def_rec_group' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_def_rec_group: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_def_signatory' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_def_signatory') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_def_signatory' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_def_signatory: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_deleted_docs' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_deleted_docs') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_deleted_docs' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_deleted_docs: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_doc' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_doc') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_doc' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_doc: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_doc_activity_values' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_doc_activity_values') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_doc_activity_values' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_doc_activity_values: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_doc_branch' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_doc_branch') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_doc_branch' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_doc_branch: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_doc_external_link' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_doc_external_link') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_doc_external_link' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_doc_external_link: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_doc_group' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_doc_group') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_doc_group' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_doc_group: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_doc_history' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_doc_history') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_doc_history' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_doc_history: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_doc_task' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_doc_task') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_doc_task' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_doc_task: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_dossier_link_detail' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_dossier_link_detail') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_dossier_link_detail' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_dossier_link_detail: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_dossier_ps' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_dossier_ps') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_dossier_ps' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_dossier_ps: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_edc_consistency_test' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_edc_consistency_test') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_edc_consistency_test' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_edc_consistency_test: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_edc_consistency_test_field' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_edc_consistency_test_field') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_edc_consistency_test_field' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_edc_consistency_test_field: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_edc_design_assembly' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_edc_design_assembly') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_edc_design_assembly' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_edc_design_assembly: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_edc_process_extension' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_edc_process_extension') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_edc_process_extension' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_edc_process_extension: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_edc_subject_assembly' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_edc_subject_assembly') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_edc_subject_assembly' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_edc_subject_assembly: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_external_link' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_external_link') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_external_link' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_external_link: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_favorite' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_favorite') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_favorite' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_favorite: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_feed' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_feed') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_feed' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_feed: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_field_mapping' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_field_mapping') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_field_mapping' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_field_mapping: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_field_value' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_field_value') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_field_value' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_field_value: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_fields_in_version' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_fields_in_version') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_fields_in_version' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_fields_in_version: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_file_delete_request' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_file_delete_request') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_file_delete_request' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_file_delete_request: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_folder_extension' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_folder_extension') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_folder_extension' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_folder_extension: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_folder_publication' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_folder_publication') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_folder_publication' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_folder_publication: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_folder_publication_model' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_folder_publication_model') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_folder_publication_model' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_folder_publication_model: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_folder_sequence' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_folder_sequence') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_folder_sequence' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_folder_sequence: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_folder_sequence_attachment' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_folder_sequence_attachment') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_folder_sequence_attachment' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_folder_sequence_attachment: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_folder_synchronization' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_folder_synchronization') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_folder_synchronization' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_folder_synchronization: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_form_gen' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_form_gen') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_form_gen' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_form_gen: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_formula_actors' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_formula_actors') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_formula_actors' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_formula_actors: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_formula_incedencies' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_formula_incedencies') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_formula_incedencies' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_formula_incedencies: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_gen_attachment' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_gen_attachment') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_gen_attachment' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_gen_attachment: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_general_settings' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_general_settings') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_general_settings' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_general_settings: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_group' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_group') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_group' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_group: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_group_members' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_group_members') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_group_members' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_group_members: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_group_team_co_mngr' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_group_team_co_mngr') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_group_team_co_mngr' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_group_team_co_mngr: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_history' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_history') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_history' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_history: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_inh_profile' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_inh_profile') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_inh_profile' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_inh_profile: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_internal_attachment' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_internal_attachment') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_internal_attachment' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_internal_attachment: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_itable_shared_field' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_itable_shared_field') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_itable_shared_field' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_itable_shared_field: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_links' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_links') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_links' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_links: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_loc' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_loc') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_loc' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_loc: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_loc_key' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_loc_key') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_loc_key' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_loc_key: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_loc_text' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_loc_text') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_loc_text' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_loc_text: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_loc_upd' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_loc_upd') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_loc_upd' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_loc_upd: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_lock' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_lock') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_lock' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_lock: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_log' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_log') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_log' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_log: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_long_text_value' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_long_text_value') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_long_text_value' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_long_text_value: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_method_call' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_method_call') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_method_call' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_method_call: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_modif_sensor' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_modif_sensor') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_modif_sensor' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_modif_sensor: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_navigator' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_navigator') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_navigator' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_navigator: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_notif' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_notif') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_notif' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_notif: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_notif_bookmarks' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_notif_bookmarks') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_notif_bookmarks' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_notif_bookmarks: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_notif_recipient' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_notif_recipient') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_notif_recipient' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_notif_recipient: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_notif_rule' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_notif_rule') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_notif_rule' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_notif_rule: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_notif_template' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_notif_template') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_notif_template' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_notif_template: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_object_delete_request' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_object_delete_request') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_object_delete_request' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_object_delete_request: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_ondemand_gen_att' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_ondemand_gen_att') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_ondemand_gen_att' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_ondemand_gen_att: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_out_field_mapping' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_out_field_mapping') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_out_field_mapping' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_out_field_mapping: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_param_field' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_param_field') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_param_field' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_param_field: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_person_attachment' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_person_attachment') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_person_attachment' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_person_attachment: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_planif' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_planif') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_planif' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_planif: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_planif_task' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_planif_task') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_planif_task' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_planif_task: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_pp_sett_val' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_pp_sett_val') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_pp_sett_val' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_pp_sett_val: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_private_units' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_private_units') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_private_units' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_private_units: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_processobject_extension' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_processobject_extension') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_processobject_extension' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_processobject_extension: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_prof_prop_sett' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_prof_prop_sett') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_prof_prop_sett' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_prof_prop_sett: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_profile' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_profile') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_profile' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_profile: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_profile_definition' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_profile_definition') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_profile_definition' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_profile_definition: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_profile_property' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_profile_property') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_profile_property' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_profile_property: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_publication_log' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_publication_log') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_publication_log' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_publication_log: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_publishing_unit' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_publishing_unit') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_publishing_unit' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_publishing_unit: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_receipt' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_receipt') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_receipt' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_receipt: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_recent_doc' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_recent_doc') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_recent_doc' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_recent_doc: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_reference' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_reference') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_reference' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_reference: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_reference_counter' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_reference_counter') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_reference_counter' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_reference_counter: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_reference_radical_elem' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_reference_radical_elem') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_reference_radical_elem' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_reference_radical_elem: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_reference_rule' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_reference_rule') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_reference_rule' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_reference_rule: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_revision_rule' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_revision_rule') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_revision_rule' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_revision_rule: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_sandbox_file' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_sandbox_file') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_sandbox_file' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_sandbox_file: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_sandbox_share' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_sandbox_share') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_sandbox_share' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_sandbox_share: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_search' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_search') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_search' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_search: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_search_display' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_search_display') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_search_display' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_search_display: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_search_export' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_search_export') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_search_export' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_search_export: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_search_export_bookmarks_elem' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_search_export_bookmarks_elem') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_search_export_bookmarks_elem' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_search_export_bookmarks_elem: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_section' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_section') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_section' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_section: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_snap_attachment' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_snap_attachment') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_snap_attachment' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_snap_attachment: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_stat_consult' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_stat_consult') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_stat_consult' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_stat_consult: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_stat_consult_cumul' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_stat_consult_cumul') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_stat_consult_cumul' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_stat_consult_cumul: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_stat_definition' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_stat_definition') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_stat_definition' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_stat_definition: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_super_activity' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_super_activity') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_super_activity' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_super_activity: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_t_u_issuers' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_t_u_issuers') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_t_u_issuers' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_t_u_issuers: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_table_content_value' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_table_content_value') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_table_content_value' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_table_content_value: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tag' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tag') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tag' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tag: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tool' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tool') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tool' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tool: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tool_method' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tool_method') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tool_method' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tool_method: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_transition' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_transition') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_transition' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_transition: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tree_content_values' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tree_content_values') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tree_content_values' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tree_content_values: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tree_struct_values' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tree_struct_values') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tree_struct_values' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tree_struct_values: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tu_activity' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tu_activity') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tu_activity' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tu_activity: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tu_activity_functions' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tu_activity_functions') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tu_activity_functions' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tu_activity_functions: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tu_conf_levels' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tu_conf_levels') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tu_conf_levels' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tu_conf_levels: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_tu_workflows' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_tu_workflows') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_tu_workflows' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_tu_workflows: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_overlays' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_overlays') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_overlays' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_overlays: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_role' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_role') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_role' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_role: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_unit' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_unit') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_unit' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_unit: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_version' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_version') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_version' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_version: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_version_forms' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_version_forms') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_version_forms' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_version_forms: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_version_locs' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_version_locs') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_version_locs' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_version_locs: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_version_pubmodels' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_version_pubmodels') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_version_pubmodels' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_version_pubmodels: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_type_version_templates' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_type_version_templates') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_type_version_templates' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_type_version_templates: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_unit' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_unit') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_unit' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_unit: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_unit_co_admins' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_unit_co_admins') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_unit_co_admins' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_unit_co_admins: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_unit_conf_levels' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_unit_conf_levels') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_unit_conf_levels' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_unit_conf_levels: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_unit_def_rec' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_unit_def_rec') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_unit_def_rec' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_unit_def_rec: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_unit_issuers' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_unit_issuers') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_unit_issuers' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_unit_issuers: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_user_licence' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_user_licence') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_user_licence' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_user_licence: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_utility_file' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_utility_file') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_utility_file' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_utility_file: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_version' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_version') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_version' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_version: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_view' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_view') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_view' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_view: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_waiting_users' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_waiting_users') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_waiting_users' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_waiting_users: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'p_workflow' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('p_workflow') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'p_workflow' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy p_workflow: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pat_doc' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pat_doc') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pat_doc' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pat_doc: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pat_doc_modif' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pat_doc_modif') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pat_doc_modif' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pat_doc_modif: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pat_utility' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pat_utility') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pat_utility' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pat_utility: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pat_utility_modif' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pat_utility_modif') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pat_utility_modif' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pat_utility_modif: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pc_autostep_processing' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pc_autostep_processing') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pc_autostep_processing' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pc_autostep_processing: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pc_conversion_server' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pc_conversion_server') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pc_conversion_server' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pc_conversion_server: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pp_auth' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pp_auth') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pp_auth' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pp_auth: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pp_conf' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pp_conf') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pp_conf' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pp_conf: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pp_deletion' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pp_deletion') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pp_deletion' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pp_deletion: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pp_myscopes' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pp_myscopes') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pp_myscopes' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pp_myscopes: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_attendee_rank' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_attendee_rank') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_attendee_rank' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_attendee_rank: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_auto_trained_persons' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_auto_trained_persons') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_auto_trained_persons' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_auto_trained_persons: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_evaluation_metadata' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_evaluation_metadata') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_evaluation_metadata' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_evaluation_metadata: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_evaluation_method' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_evaluation_method') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_evaluation_method' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_evaluation_method: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_field_mapping' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_field_mapping') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_field_mapping' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_field_mapping: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_roles' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_roles') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_roles' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_roles: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_team' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_team') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_team' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_team: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_team_members' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_team_members') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_team_members' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_team_members: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_trained_group' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_trained_group') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_trained_group' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_trained_group: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_training_doc' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_training_doc') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_training_doc' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_training_doc: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_training_history_entry' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_training_history_entry') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_training_history_entry' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_training_history_entry: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_training_metadata' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_training_metadata') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_training_metadata' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_training_metadata: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_training_module' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_training_module') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_training_module' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_training_module: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_training_module_comanager' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_training_module_comanager') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_training_module_comanager' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_training_module_comanager: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'ptm_training_process' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('ptm_training_process') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ptm_training_process' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy ptm_training_process: ' + ERROR_MESSAGE(); END CATCH; GO BEGIN TRY DECLARE @SearchValue NVARCHAR(MAX) = N'KR MCQ test 4'; DECLARE @SQL NVARCHAR(MAX) = ''; SELECT @SQL += ' SELECT ''' + 'pvalerttaskpo' + ''' AS źródło_tabeli, * FROM ' + QUOTENAME('pvalerttaskpo') + ' WHERE ' + STUFF(( SELECT ' OR TRY_CAST(' + QUOTENAME(COLUMN_NAME) + ' AS NVARCHAR(MAX)) = @SearchValue' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'pvalerttaskpo' FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 4, '') + ';'; EXEC sp_executesql @SQL, N'@SearchValue NVARCHAR(MAX)', @SearchValue = @SearchValue; END TRY BEGIN CATCH PRINT 'Błąd przy pvalerttaskpo: ' + ERROR_MESSAGE(); END CATCH; GO