SQL Server FILESTREAM总文件大小 [英] Sql Server FILESTREAM Total File Size

问题描述

是否有一个查询可以让我获得磁盘上FILESTREAM文件夹中文件的总文件大小?

Is there a query that would get me the total file size of the files that are in the FILESTREAM folder on the disk?

推荐答案

以下查询将返回filestreamcolumn列的字节长度:

The following query will return the length in bytes of the filestreamcolumn column:

SELECT SUM(DATALENGTH(filestreamcolumn)) FROM filestreamtable;

来源

这篇关于SQL Server FILESTREAM总文件大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！