Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the diff between Dynamic queries and static queries

Question Posted / bhaskar


What is the diff between Dynamic queries and static queries ..

Answer / jerry joseph

Static query will be executed as it is.

Dynamic query is built upon conditions depending upon the
parameters.

Static query will create an execution plan during compilation.

Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.

Is This Answer Correct ?    17 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is a Trace frag?Where can we use this?

1 Answers  

Explain the different index configurations a table can have?

0 Answers  

What do you understand by intent locks?

0 Answers  

What are a database and a data warehouse?

0 Answers  

Explain activity monitors

0 Answers  

What is raid, and how it can influence database performance?

0 Answers  

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

What is normalization of database?

0 Answers  

how insert selected column only ?

3 Answers   Robert Half,

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

When we should use and scope of @@identity?

0 Answers  

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories