SQL Quqries:

1) Searching Procedures in Database.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%foobar%'
AND ROUTINE_TYPE='PROCEDURE'

2) Searching DB objects contains the field 'TEI':
SELECT DISTINCT OBJECT_NAME(B.[OBJECT_ID]), A.[NAME] FROM SYS.COLUMNS A
INNER JOIN SYS.OBJECTS B
ON A.[OBJECT_ID] = B.[OBJECT_ID]
WHERE A.[NAME] LIKE '%TEI%'

3) Finding Duplicate in Table1 and Table2:
SELECT col1,col2,col3,COUNT(*)
FROM table1 A
INNER JOIN table2 B
ON A.col1 = B.col1
AND A.col2 = B.col2
GROUP BY col1,col2,col3
HAVING COUNT(*) > 1

4) Finding nth Max sal in EMP table.
EMP Table and find the 2nd height Salary?

Method1
select min(sal) from EMP p1 where 2=(select count(*) from EMP p2 where p1.EMPID>=p2.EMPID)
Method2
select max(sal) from (select top 2 sal from EMP order by sal asc) t

Interview 1 Questions
Unix:
1) How to Run Application in Back Ground Process?
./prog_name&
2) How to see the Running Back Ground Process?
?
3) How to find the File which have size > 100 KB?

Thanks,
Arun Mannepula