Answer Posted / rita

xp means experience

What is the difference between function and stored procedure in sql server?

488

---

Can the “if update (colname)” statement be used in a delete trigger?

558

---

What is a DBMS, query, SQL?

575

---

What is named query? : sql server analysis services, ssas

517

---

What is @@error in sql?

623

---

---

What is BCNF? How is it better than 2NF & 3NF?

597

---

Is ssrs support other database except ms sql server?

96

---

Describe in brief authentication modes in sql server.

569

---

Find columns used in stored procedure?

529

---

What is your recommendation for a query running very slow? : sql server database administration

593

---

Is mysql better than sql server?

540

---

what is the difference between Delete and Truncate command in SQL

628

---

What is dirty read?

628

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

529

---

how to create “alternate row colour”?

109

---