Lapozás LapozásLapozás LapozásBezár BezárVálasz felvitele Válasz felvitele
Előzmény:Document Link Icon
Készítette:weelere
Dátum:2022.11.13, Vasárnap 17:02 (Javítás: 6/06/2025, Péntek 1:20 PM)
Tárgy:??

DECLARE @SearchString NVARCHAR(100) = 'keresett_szoveg';
DECLARE @sql NVARCHAR(MAX) = '';

SELECT @sql += '
IF EXISTS (SELECT 1 FROM [' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']
WHERE [' + COLUMN_NAME + '] LIKE ''%' + @SearchString + '%'')
PRINT ''Találat: [' + TABLE_SCHEMA + '].[' + TABLE_NAME + '].[' + COLUMN_NAME + ']''
'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext');

EXEC sp_executesql @sql;



DECLARE @SearchString NVARCHAR(100) = 'keresett_szöveg';
DECLARE @sql NVARCHAR(MAX) = '';

SELECT @sql += '
BEGIN TRY
SELECT ''' + TABLE_SCHEMA + '.' + TABLE_NAME + ''' AS TableName,
''' + COLUMN_NAME + ''' AS ColumnName,
[' + COLUMN_NAME + '] AS MatchValue,
*
FROM [' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']
WHERE [' + COLUMN_NAME + '] LIKE ''%' + @SearchString + '%''
END TRY
BEGIN CATCH
-- skip errors for incompatible data types
END CATCH
'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext');

EXEC sp_executesql @sql;



Utolsó módosítás: 2025.06.06