Bleary-eyed ruminations of a work at home Father.
Problem: I need to know the size in bytes of an image stored in an Image column in SQL 2005.
Solution: SELECT DATALENGTH(image) FROM schematicsimage WHERE [schematicsid] = 527
(Courtesy of Bruce the DBA)
Thanks. this is most helpful,but do you know how to convert the lenght to actual byte size and hot to get the resolution of the image?
helped me out today, thanks
Post a Comment
The Leadership Journey