如何执行Sql语句 [英] How Sql statements are executed

问题描述

嗨



我想知道sql查询语句是如何执行的。我的意思是执行语句的优先级。例如，在我的查询语句中，我使用了子查询，连接，函数或条件，所以它将以优先方式执行。



请帮助我顺利执行sql查询语句。



Thamks。

Hi

I Want to know that how the sql query statements are executed. What i mean is in which precedence the statements are executed. For example in my query statements i used subqueries,joins,functions,or,and conditions So in which precedence way it will executed.

Kindly assist me to get the way of execution of the sql query statements.

Thamks.

推荐答案

Microsoft SQL Server查询处理器内部和架构 [ ^ ]应该回答您的一些问题。< br b> b b b b b b b b b b b b b b b b b b b b b b b b - 计划> SQL Server执行计划 [ ^ ]是必读书。

Microsoft SQL Server Query Processor Internals and Architecture [^] should possibly answer some of your questions.

If you are looking specifically for query execution, SQL Server Execution Plans[^] is a must read book.

这篇关于如何执行Sql语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！