Answer Posted / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

What is the difference between a local and a global temporary table?

625

---

How do you Implement SSIS Packages in your Project?

1511

---

What is use of except clause? How it differs from not in clause?

601

---

How sql server enhances scalability of the database system?

592

---

What is the importance of concurrency control?

665

---

---

Where views are stored in sql server?

557

---

What is log shipping?

560

---

How to concatenate two character strings together?

569

---

Can we update data in a view?

601

---

Why we use functions in sql server?

520

---

What is raiseerror? What is raiseerror?

644

---

Explain insert into select statement?

523

---

What are the limitations/drawbacks or ssrs 2008 r2?

86

---

Explain filtered indexes benefits?

593

---

what is the maximum size of a row? : Sql server database administration

534

---