Answer Posted / prakash

magic table are thouse on which we manuclate on data

What happens if the update subquery returns multiple rows in ms sql server?

584

---

How to find the source of a table in sql server?

522

---

Difference between report and query parameter.

591

---

Where sql server usernames and passwords are stored in a sql server?

489

---

Explain external key management in sql server 2008

497

---

---

What is oltp (online transaction processing)?

580

---

Does the unique constraint create an index?

559

---

What is importing utility?

544

---

Explain what is dbcc?

592

---

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

535

---

What is set nocount on and what is set nocount off?

512

---

What are dml triggers and types of dml triggers?

543

---

What is implicit mode in sql server?

552

---

Explain trigger and its types?

607

---

How to drop existing views from a database in ms sql server?

524

---