Answer Posted / vial

stored proceure compiles only once and stores in database
managemant system so it is optimized for best performance
while sql query compiles every time and executes using dbms
driver so its performance decreses

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

556

---

what exactly sql injuction.how to overcome.....

2043

---

List the different types of joins?

568

---

What is merge replication?

714

---

How to create stored procedures with parameters in ms sql server?

526

---

---

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

590

---

Detail about the hardware which is supported by SQL server?

589

---

How efficient you are in oracle and SQL server?

642

---

What is collation?

715

---

How to use “drop” keyword in sql server and give an example?

688

---

What are the types of subscriptions in SQL Server replication?

550

---

What is @@error in sql?

623

---

Do you know what are acid properties of transaction?

526

---

How is table type constraint applied to a table?

551

---

can an automatic recovery be initiated by a user? : Sql server administration

518

---