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
Post a Comment
Subscribe (RSS)
The Leadership Journey
3 comments:
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
Post a Comment