query will be compiled each time excution stored procedure will be compile

Difference between a query and strored procedure?

Question Posted / tathagoto

Answer Posted / tathagoto

query will be compiled each time excution
stored procedure will be compiled once and after that it
will execute when it will be called....

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you write an inner join query?

936

What are the types of triggers in sql?

1067

What does pragma mean?

1035

what are the type of locks ? : Sql dba

944

How do you clear the screen in sql?

1054

What is on delete set null?

1071

who introduced sql?

999

What is sql analyzer?

996

How is use pl and sql?

1050

Explain autonomous transaction.

1148

Does pdo prevent sql injection?

920

How do you update a table in sql?

965

what is rdbms? : Sql dba

998

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1023

Can we use ddl statements in stored procedure sql server?

990