本文介绍了sql-server-如何在SQL Server中查找查询的网络流量?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
sql server中是否有任何可能的方法来找出单个select语句多少字节/KB?
Is there any possible ways in sql server to find out how many bytes/KBs for a single select statement?
推荐答案
SELECT * FROM employee where YEAR(InsertDate)=2012
我想知道要提取多少数据.
对于Taht，我将这些插入到temp表中并使用sp_spaceused.
I want to know how much data its going to fetch.
For taht i am going to insert these into temp table and use sp_spaceused.
SELECT *
INTO dbo.temptable
FROM employee where YEAR(InsertDate)=2012
exec sp_spaceused temptable
DROP TABLE temptable
这篇关于sql-server-如何在SQL Server中查找查询的网络流量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！