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

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

HOW TO RENAME A COLUMN NAME

3 Answers  

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

What is a ddl statement?

0 Answers  

What are sql server functions?

0 Answers  

What value could be assigned to Varchar Type?

3 Answers  

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

What are the triggers in sql?

0 Answers  

What is outer join in sql server joins?

0 Answers  

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

How to use go command in "sqlcmd"?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories