Finding the Length of an Image Field in SQL Server
Posted by Tim on November 19, 2009 in SQL Server |
Problem: I need to know the size in bytes of an image stored in an Image field in SQL Server
Solution: SELECT DATALENGTH(column) FROM table
-
-
-
CodeLab Twitter- codelabnz: @possiblyb9 I now have blackberry for breakfast February 7, 2012
- codelabnz: I have now joined most ppl in indonesia and got myself a blackberry February 7, 2012
- codelabnz: From a bb February 6, 2012
- codelabnz: @bartekmarnane some info on micro orms http://t.co/UDfv5ML7 February 5, 2012
- codelabnz: @bartekmarnane depends on the project, but i found u have 2 be very careful with EF and the type of SQL it generates February 5, 2012
- codelabnz: @bartekmarnane I have been using EF for awhile, good for building apps quickly, but found it performs bad on higher traffic web applications February 5, 2012
- codelabnz: stuff it, I give up on Entity Framework, going to a micro ORM, back to writing SQL queries! I would rather do this than have a slow app! February 5, 2012
- codelabnz: Been too busy for tweeting lately January 21, 2012
- codelabnz: Blog Post: Setting the screen position when visiting previous page with jQuery http://t.co/evuKxVv0 January 17, 2012
- codelabnz: is anyone using Godaddy Cloud hosting? can someone provide their website so I could do a speed test? January 9, 2012