Length of varbinary(max) filestream on SQL Server 2008

sql-server filestream varbinary datalength
TcKs picture TcKs · Apr 14, 2009 · Viewed 8.8k times · Source

Is there some efficient way how to get length of data in "varbinary(max) filestream" column? I found only samples with conversion to varchar and then calling the "LEN" function.

Answer

Jan Remunda picture Jan Remunda · May 12, 2009 
SELECT
      length = DATALENGTH(Name),
      Name 
FROM 
      Production.Product 
ORDER BY 
      Name

"Returns the number of bytes used to represent any expression."

T-SQL and quote taken from MSDN's DATALENGTH (Transact-SQL) library.

Related questions

Create table throws an errror "Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), non-FILESTREAM columns."

I have a table which one field use filestream. If I right click and create a create table the T-SQL is: USE [CMMS] GO /****** Object: Table [dbo].[Ficheros] Script Date: 05/09/2014 12:48:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO …

Read More
SQL Server FILESTREAM limitation

I am looking at FILESTREAM attribute in SQL Server to store files in it. I understand it stores the files on hard drive and stores the file pointer/path information in DB. Also, maintains transactional consistency in the process. There …

Read More
Check SQL Server 2008 Filestream status

I'm using the SQL Server 2008 filestream feature in one of my projects, is there a way to check the filestream status (if it's enabled or not) using a query?

Read More