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 are the differences between sql server and mysql.

1137

What part does database design plays a role in performance of an sql server-based application?

1032

How can we solve concurrency problems?

1096

how you can deploy an ssrs report?

185

What are the options which must be set to allow the usage of optimistic models?

1020

optimization techinques

2717

How to use values from other tables in update statements in ms sql server?

1180

What are the different authentication modes in sql server? How can it be changed?

1138

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3919

Does the unique constraint create an index?

1133

What is a domain constraint give an example?

1108

Which rendering formats are affected by the pagesize properties?

151

What are the types of dml?

1027

What are the five major components of a dbms?

961

What is a print index?

932