Answer Posted / anjum

SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY)
FROM EMP)

Explain powershell included in sql server 2008?

617

---

Do you know what is blocking?

543

---

Why should one not prefix user stored procedures with ‘sp_’?

597

---

Explain about temporary stored procedure?

532

---

Do you know what are various aggregate functions that are available?

529

---

---

How to start sql server browser service?

564

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

522

---

Can we call stored procedure in view in sql server?

500

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1436

---

Why do we need different type of parameter?

550

---

How to use group functions in the select clause in ms sql server?

540

---

Where is my database stored on the hard disk in ms sql server?

596

---

Can We Use Data-grids For Our Report In Ssrs?

147

---

User wants only to display only pdf as export option in report manager. How to achieve this?

173

---

What is the difference between left and right outer join?

547

---