What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

How you can change a cross join into an inner join?

0 Answers  

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

How the data stores in a page?

1 Answers  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---