Answer Posted / johnny

Magic? I'm still waiting for the rabbit to appear...

What is a transaction and why is it important?

745

---

What are advantages of ssrs or why we should use ssrs?

117

---

What is statement level trigger?

757

---

How global temporary tables are represented and its scope?

722

---

Do you know what is sql injection?

724

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

753

---

How to use old values to define new values in update statements in ms sql server?

875

---

Differentiate between delete and truncate.

754

---

Why Master database is required?

763

---

What does set rowcount do?

693

---

What are translations and its use? : sql server analysis services, ssas

801

---

What are the types of user defined functions in sql server?

721

---

What is an identity column in insert statements?

752

---

How to compare the top two records using sql?

965

---

Can we call stored procedure in trigger?

726

---