Answer Posted / ravi pahuja

selecl distinct top 2 salories from emp order by salory desc

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1393

---

What is scalar user-defined function?

537

---

Define magic tables in sql server?

559

---

What is cdc in sql server?

560

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

650

---

---

Explain triggers?

547

---

What do you understand by mirroring?

558

---

Are connections to sql server encrypted?

566

---

Describe in brief system database.

534

---

How to find which stored procedure is currently running in sql server?

484

---

What stored procedure can you use to display the current processes?

487

---

Tell me can we use custom code in ssrs?

586

---

What is recompile sql server?

552

---

What does normalization do to data?

532

---

Do you know what are acid properties of transaction?

516

---