Answer Posted / yogendra kumar

extra expereince

What is the purpose of floor function?

543

---

What are sp_configure commands and set commands?

566

---

Can a table have 2 foreign keys?

509

---

Why use cursor in sql server?

554

---

how we use window authentication connection with sql server.?

634

---

---

Explain full-text query in sql server?

542

---

Define indexes?

609

---

Explain rdbms?

607

---

What will be the maximum number of index per table?

592

---

What is global temp table?

567

---

Describe triggers features and limitations?

508

---

What is create command?

526

---

How to use subqueries with the exists operators in ms sql server?

590

---

What do you understand by recursive stored procedures?

572

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

558

---