Answer Posted / suresh jp

select emp_no,max(salary) over() from table_employee;

How can you insert values in multiple rows using one Insert statement?

604

---

How to test subquery results with the exists operator?

551

---

Why we use trigger in sql server with example?

501

---

What is the New in SQL server 2008?

565

---

Why and when do stored procedure recompile?

542

---

---

Explain time data type in sal server 2008?

538

---

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

570

---

What are the different SQL Server Versions you have worked on?

534

---

How can you control the amount of free space in your index pages?

594

---

What is save transaction and save point?

614

---

how would you improve etl (extract, transform, load) throughput?

526

---

What are the aggregate and scalar functions?

507

---

Define candidate key, alternate key, and composite key.

526

---

How ssrs maintain security?

566

---

What do we have to check in database testing?

573

---