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 a join and explain different types of joins? : Sql server database administration

962

How to create a local temporary stored procedure?

998

What is the largest component inside a field?

1130

Describe the functionalities that views support.

1105

Explain cross join or cartesian product in sql?

893

What is the use of keyword with encryption.

1031

How to retrieve error messages using mssql_get_last_message()?

1056

How to list all columns in a table using odbc_columns()?

976

Explain security with sql azure?

186

How to create percentile function?

156

What is a deadlock and what is a live lock?

1003

What is a constant or literal in ms sql server?

1049

List some major differences between triggers and stored procedures?

937

is there a column to which a default can't be bound? : Sql server database administration

1016

What are “phantom rows”?

1666