Otomatis menjalankan pencarian ke semua tabel

 DECLARE @NIP VARCHAR(50) = '123456789';
DECLARE @SQL NVARCHAR(MAX) = '';

SELECT @SQL = @SQL +
'
IF EXISTS (
    SELECT 1
    FROM [' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']
    WHERE nip = ''' + @NIP + '''
)
BEGIN
    PRINT ''Ditemukan pada: ' + TABLE_SCHEMA + '.' + TABLE_NAME + ''';
END
'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'nip';

EXEC sp_executesql @SQL;