Trending Query Analyzer Discussions

Whats the difference between Query and Stocked procedure ?‎

What is cube or multidimensional query?‎

 

Answer added by  Shagufta Mubasher, Web Developer, MP CJ O Shopping Sdn. Bhd.
10 years ago

If you mean to say difference between a SQL query and SQL stored procedure, I am differentiating it below. Every query is submited it will be compiled & then executed ... See More

 

Answer added by  Manik Hussain, English Teacher(grammar and speaking), Aptech Education
8 years ago

Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases MDX is a query language that is used ... See More

 

Answer added by  Reem AlJeaid, Strategic Partnership Development AVP, صندوق الاستثمارات العامة السعودي
8 years ago

Multidimensional Expressions (MDX) is the query language that you use to work with and retrieve multidimensional data in Microsoft Analysis Services. MDX is based on the ... See More

 

Answer added by  waqas ahmed
8 years ago

cube is a language for expressing analytical quries. cube is the extention to the Ms SQL.

 

Answer added by  DURGESH YADAV, ASSISTANT PROGRAMMER, DISTRICT ELECTION OFFICE DEORIA
10 years ago

The diffrence between query and stocked procedure is: Query: The phase that identifies an efficient execution plan for evaluating a query that has the least estimated cos ... See More

 

Answer added by  Binu JOSEPH, SOFTWARE ARCHITECT, KUWAIT TECHNICAL UNIVERSITY
8 years ago

Cube is a multidimensional database for Online Analytical Process (OLAP). Multidimensional Query or MDX is the scripting language is using to extract output form an OLAP ... See More

 

Answer added by  Deva Gnanam Jayaseelan, Lead SSE, MS
10 years ago

Query and stored procedure do the same thing but the difference is that a query should be compiled everytime the query is executed,while the stored procedure is in compil ... See More