Generate query untuk mencari NIP tertentu di semua tabel tersebut

 SELECT 
    'SELECT ''' + TABLE_NAME + ''' AS TableName, * FROM [' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] WHERE nip = ''123456789'''
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'nip';