Answer Posted / sandeep

magic table two part
1)Inserted
a)Insert
b)update
2)Deleted

What is difference between group by and having?

566

---

What are the differences between char and nchar in ms sql server?

537

---

How to select some specific columns from a table in a query in ms sql server?

505

---

What is the parse query button used for?

607

---

When is the use of update_statistics command?

554

---

---

What command is used to delete a table from the database in the sql server and how?

545

---

How will you monitor replication latency in transactional replication? : sql server replication

616

---

what is an index? : Sql server database administration

523

---

What are the different types of collation sensitivity?

559

---

Explain rdbms?

606

---

What is the tcp/ip port on which sql server runs?

570

---

Is candidate a key?

536

---

What is subreport?

100

---

What is the library index called?

594

---

How and why use sql server?

554

---