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 are file groups?

3 Answers   Evalueserve,

Explain go command in sql server?

0 Answers  

What is lookup override?

0 Answers   Informatica,

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

Which are the new data types introduced in sql server 2008?

0 Answers  

List the different normalization forms?

0 Answers  

What is function of ROLLUP ?

0 Answers   HCL,

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

Can we add a cpu to sql server?

0 Answers  

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

Explain what are the events recorded in a transaction log?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories