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?
شكراthanksنهادnihad
helped me out today, thanks
Thanks. this is most helpful,
ReplyDeletebut do you know how to convert the lenght to actual byte size and hot to get the resolution of the image?
شكرا
ReplyDeletethanks
نهاد
nihad
helped me out today, thanks
ReplyDelete