. Comparison of image type data in SQL Server

Original:. Comparison of image type data in SQL Server

In SQL Server, if you are comparing data for text, ntext, or image data types. You will be prompted that you cannot compare or sort the text, ntext, and image data types unless you are using the is NULL or like operator. However, image does not support like comparisons.
So how do you compare the pictures in the database?
For the processing of this large object, there are special function Dbms_lob.compare in Oracle, and there is no special processing function in SQL Server.
You can only intercept data from image data by using the SUBSTRING function for a period of time, up to a maximum of 8060 bytes (8k),
The varbinary type data is then compared. Here is an example of a function that compares an image:

The content from my QQ space in 2009-6-17 16:10 published the journal. NET turn.

. Comparison of image type data in SQL Server