SQL query will be compiled everytime it is executed. Stored procedures are

Difference between writing SQL query and stored procedure ?

Question Posted / ashwini

Answer Posted / ashwini

SQL query will be compiled everytime it is executed.
Stored procedures are compiled only once when they are
executed for the first time.

Is This Answer Correct ?

209 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What is an index in a database?

919

What is join query?

835

Which joins are sql server default?

935

What are the recovery models in sql server 2000?

925

Distinguish between commit and rollback?

894

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

992

What is proper subset of candidate key?

944

Explain what is sql server english query?

984

Can you force a query to use a specific index?

885

What are the various editions of sql server 2017 that are available in the market?

841

What are the advantages of partitioning?

1040

How to update multiple rows with one update statement in ms sql server?

1132

What stored by the msdb?

949

What is optimistic concurrency?

970

how will add additional conditions in sql?

1008