Answer Posted / haribabuboddapati

select max(sal)*from emp
where sal>select max(sal)*from emp

How to define output parameters in stored procedures?

1027

---

How many non clustered indexes there can be on table ?

920

---

How to copy the tables, schema and views from one sql server to another?

1047

---

What is resource governor in sql server?

995

---

Explain the advantages of merge replication?

951

---

How to delete database objects with "drop" statements in ms sql server?

1089

---

What is difference between rownum and rowid?

902

---

What happens if null values are involved in comparison operations?

971

---

what is the difference between a primary key and a unique key? : Sql server database administration

997

---

How to check if a table is being used in sql server?

962

---

What do you mean by the term 'normalization'?

1209

---

how can a database be repaired? : Sql server administration

971

---

What is the fastest way to permanently delete a 1 million row table named customers?

1255

---

what is datawarehouse?

1113

---

Explain the third normal form(3nf)?

943

---