执行任何查询时会发生什么 [英] What Is Happen when any query get executed

问题描述

在项目上工作时，我会执行很多查询，例如选择，插入，联接等.
当我执行任何查询时，它将返回类似int ar数据集的内容，具体取决于查询.

Working on a project i execute lots of query like select,insert,joins etc.
When I execute any query it will return something like int ar dataset depend on query. What happens when any query is executed,where the query is compiled,how it differentiate between different syntaxes?

推荐答案

请参阅此链接..
你有个主意..

SQL Server执行时会发生什么 [

Hi,

Refer this link..
You get some idea..

What happens when SQL Server executes[^]

Cheers :)

除了T.Saravanann的回答之外，请尝试使用SQL事件探查器查看SQL Server收到请求时会发生什么.它将向您确切显示SQL Server在做什么.

http://msdn.microsoft.com/en-us/library/ms187929.aspx [ ^ ]

In addition to the answer by T.Saravanann, try using SQL profiler to see what happens when your SQL Server receives requests. It will show you exactly what SQL Server is doing.

http://msdn.microsoft.com/en-us/library/ms187929.aspx[^]

这篇关于执行任何查询时会发生什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！