Answer Posted / sudama maharana

1. Stored procedure is loaded to database once it compiled, but inline queries are not loaded in to server. So, Stored procedure is in compiled form.

2. As Stored procedure is in compiled form, so in each calling to it, it takes less time than inline queries. Because in Stored procedure we are passing only the names, but in inline query we are passing the whole query.

3. Stored procedures are compiled only once and in each calling its only executing the query. But inline queries are compiled & executed in each calling. So, in stored procedure network Traffic is less.

4. In stored procedure, we can pass parameters . But in inline query we can't pass.

Thanks

What is sql analyzer?

1025

---

What are commit, rollback, and savepoint?

996

---

Which type of cursor is used to execute the dml statement?

958

---

What is an implicit commit?

1058

---

How many sql core licenses do I need?

945

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

---

What is time based sql injection?

960

---

What are the different sql commands?

1073

---

What are the different dml commands in sql?

1176

---

What is meaning of <> in sql?

1070

---

how to use case expression? : Sql dba

1028

---

what is the use of double ampersand (&&) in sql queries?

1176

---

What is the difference between left outer join and left join?

995

---

how to create a new table in mysql? : Sql dba

986

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1433

---