Answer / ela tiku

At runtime the compiler first takes the table name from
where the data is to be retrieved (FROM <tablename>), then
it checks for the condition (Where <condition>) then it
selects the values to me displayed as o/p

Answer / nandkumar karlekar

The order of Execution is as follows
1.From clause and joins
2.independent subqueries in the where clause
3.where clause last condition execute first but if the
index is present then these condiyions execute first

Answer / l. meher

When a SQL query is getting executed it goes through the
following steps:

1) It goes to the shared pool which contains information
such as the parse tree and execution plan for the
corresponding statement.
2)Validate the SQL statement.
3)Validate the source.
4)Acquire locks.
5)Checks for previllages.
6)Parse the statement.
7)Execute the Query.
8)Fetch the value (only for select statement).
9)Generate the redo information.

If you have any doubt mail me at lmeher.tcs@gmail.com
Thanks..

Answer / selvam

FROM
ON
JOIN
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
ORDER BY
TOP

Answer / suraj

Though it's not so clear on what type of SQL query.
If we want to see in what order does the SELECT query
executes; it'l like this.

SELECT .........
FROM ..........
WHERE ..........
GROUP BY ...........
HAVING ............

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

Why would you call update statistics?

0 Answers  

What is sparse columns of sql server 2008?

0 Answers  

What is the New in SQL server 2008?

0 Answers  

What is extended stored procedures?

0 Answers  

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

IN Vs OR operator which is best to use sql server.

4 Answers  

What is sql stored procedure?

0 Answers  

Why are you getting errors when creating a new odbc dsn?

0 Answers