Answer Posted / krish

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

Tell me what is sql profiler?

997

---

What is 2nf normalization?

982

---

What is the difference between clustered and a non-clustered index?

998

---

Write the syntax for stuff function in an sql server?

998

---

What does it mean to normalize a database and why would you do it?

956

---

can an automatic recovery be initiated by a user? : Sql server administration

920

---

Why I have to use stored procedures?

995

---

How to defragment table indexes?

948

---

How to use union to merge outputs from two queries together in ms sql server?

1027

---

What are database states in ms sql server?

1135

---

Define cross join in sql server joins?

982

---

How to receive output values from stored procedures?

1090

---

what are database files and filegroups? : Sql server database administration

908

---

Can we deploy SSRS reports on our personal website?

168

---

What is format parameter in ssrs?

140

---