Answer Posted / krish

select max(sal) frem tbl where sal <(select max(sal) from tbl;

How do you use a subquery to find records that exist in one table and do not exist in another?

1091

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1045

---

what are different types of raid configurations? : Sql server database administration

1103

---

what stored procedure would you use to view lock information? : Sql server administration

1024

---

Find first and last day of current month in sql server

1082

---

What is normalization and its types?

1078

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1136

---

Can you explain different types of joins?

991

---

How to create an multi-statement table-valued function?

1050

---

What is precedence constraint?

1039

---

What is sql server replication? : sql server replication

1040

---

Write a code to select distinct records without using the DISTINCT keyword.

1186

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1006

---

Explain what is lock escalation?

1113

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1193

---