Answer Posted / azahar

Extended procedure....

How to return the date part only from a sql server datetime datatype?

582

---

What is the difference between a view and a stored procedure?

565

---

Define magic tables in sql server?

573

---

What will be the maximum number of indexes per table?

537

---

How to get a list of columns in a view using the "sp_help" stored procedure?

576

---

---

What happens if we shrink log file in sql server?

521

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

598

---

What is a system database and what is a user database?

582

---

How to create an multi-statement table-valued function?

532

---

Where are full-text indexes stored?

575

---

How many instances per computer are there in sql server 2000?

584

---

Does table partitioning improve performance?

536

---

What is collation?

715

---

Why do you want to join software field as you have done your BE in Electronics?

1707

---

How do I trace a query in sql server?

543

---