November 29, 2004 at 9:47 am
I have an image column in the table that stores PDF files. I need to check the size of a particular PDF document and compare it with actual file in NTFS system. Any suggestions on how to do it?
-Nitin
November 29, 2004 at 2:54 pm
Nitin,
You can get the byte size of the image column by using the SQL function Datalength.
select datalength(image_column) from MyTable
Scott Thornburg
Volt Information Sciences
November 30, 2004 at 12:53 am
May I ask, why you keep the file in an image column AND on the filesystem? Or do you need this to determine if the file was updated? Anyway, here's a very good link on BLOBs and SQL Server http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply