<< More WinForms madness | Innovative use of the SQL Server row_number() function >>

Length of image columns - DATALENGTH function

by dotnetpete 25. June 2009 16:42

I needed to find the length of an image column in the database. You can use the LEN function on varbinary columns but not image columns.

The DATALENGTH function however does work very nicely.

73822e9b-4e64-402b-8130-c4e995a105f6|0|.0

Tags:

SQL

SQL Replace not working with Text columnsAn annoying limitation of the SQL Server REPLACE function is that it doesn't operate on TEXT dat...Replication in SQL2008 of XML data type columnsSeems that XML data type columns are not replicated (via merge replication anyway) between sites. Bu...Innovative use of the SQL Server row_number() functionI came across an interesting use of the row_number function today. Say you have a situation where yo...

Comments

8/25/2009 4:11:45 AM #

Thank you for your help!Thank you and My best regards! Thank you and Sorry for so many questions but i really need your help.

bad credit loans

9/15/2009 3:34:44 PM #

amazing stuff thanx

payday loan

10/22/2009 12:19:19 PM #

Do you make money out of this blog? just curious

fast cash advance

11/12/2009 12:35:40 PM #

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it.

Option Trading

11/13/2009 12:39:53 PM #

Dude.. I am not much into reading, but somehow I got to read lots of articles on your blog. Its amazing how interesting it is for me to visit you very often.

Las Vegas SEO

11/14/2009 11:46:27 AM #

I admit, I have not been on this webpage in a long time... however it was another joy to see It is such an important topic and ignored by so many, even professionals. I thank you to help making people more aware of possible issues.
Great stuff as usual...

Lyrics

11/16/2009 3:07:49 PM #

Keep 'em coming... you all do such a great job at such Concepts... can't tell you how much I, for one appreciate all you do!

press release format

Add comment