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 t-sql script to take database offline – take database online.

591

What are the components of sql server service broker?

498

do views contain data ?

573

Explain what is analysis service repository?

528

How to make conditional sum in ssrs?

128

What is sql server profiler?

558

Explain how many normalization forms?

569

List the various tools available for performance tuning?

474

What is the difference between upgrade and migration in sql server?

581

Why use sub query in sql server and list out types of sub queries?

530

Tell about MOM Tool(Microsoft Operator Manager)?

1405

Can we do dml on views?

542

Explain datetimeoffset data type in sal server 2008?

525

Does hive support indexing?

509

Do you know what are pages and extents? : SQL Server Architecture

537