Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-04-21 : 07:50:17
|
| Hi All,I need some help from u..I wanted to know the exact flow behind SQL Server when we fireSELECT select_list [ FROM table_source ] [ON Join_Condition][ WHERE search_condition ] [ GROUP BY group_by_expression ] [ HAVING search_condition ] [ ORDER BY order_expression [ ASC | DESC ] ] what is exact execution process mean which get first strike to server and then what followed then..T.I.A |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-21 : 09:57:59
|
not sure exactly what you are asking for. if you want to know the query plan for a query, then run it in SSMS with the "include actual execution plan" button checked.if you want to see the plan without running the query, you can use the "show estimated execution plan" button.
elsasoft.org |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-04-22 : 00:32:01
|
| I m asking for sequence of this..first it will execute where condition or join condition or group by or having condition ...like thatT.I.A |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-22 : 09:38:41
|
You have to look at the query plan to find out how sql server will do things for a given query. SQL is a declarative language. you say what you want, not how you want the server to do it. to find out how it will do it, you have to look at the query plan.
elsasoft.org |
|
|
|
|
|
|
Select Syntax Execution in Server behind..