Re: query against blob objects

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 08/08/04 

Date: Sun, 8 Aug 2004 22:21:01 +0000 (UTC)

Jacky Luk (jl@knight.com) writes:
> What is the general SQL syntax statement for accessing blob objects?
> I've looked mySQL,they said there is a limitation and the limitation is
> you have to 'trim' each field so that they are the same length before
> you do a 'compare' on it. I'm wondering SQL Server would have been the
> same. I used the following statement to access mySQL Blob objects select
> * from s_proc where contents = 'calkslaj' (did not succeed)

But you got an error message which might have given you a hint:

   CREATE TABLE s_proc (a int NOT NULL, b text NOT NULL)
   go
   INSERT s_proc (a, b) VALUES (1, 'Kilroy was there')
   go
   SELECT * FROM s_proc WHERE b LIKE 'Kilroy was there%'
   go 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • query against blob objects
    ... What is the general SQL syntax statement for accessing blob objects? ... I've looked mySQL,they said there is a limitation and the limitation is you ...
    (microsoft.public.sqlserver.programming)
  • Re: query against blob objects
    ... >> What is the general SQL syntax statement for accessing blob objects? ... >> I've looked mySQL,they said there is a limitation and the limitation is ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
    (microsoft.public.sqlserver.programming)
  • Re: Why cant recursive queries contain...?
    ... imagine that you have a gross amount of data spread ... SQL, and the optimizer will make sure that you get a new query plan as ... If you really think the limitation of 8000 chars gets in your way, ... The analogy was not meant to denigrate LINQ ...
    (microsoft.public.sqlserver.programming)
  • Re: Partitioned view - updating
    ... -- the limitation seems to be an implementation limitation or a ... > constraints and evaluations of nested relational expressions. ... To allow updates on all ... > itself is mostly impossible and therefore the view update rules in SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: Agents and thread limits from SQL 2005 Distributor machine
    ... I am unaware of any such limitation for Standard and Enterprise Editions. ... limit as to the number of log reader agents/distribution agents that can be ... Looking for a SQL Server replication book? ... This article below show us some limitation from sql 2000 about log reader ...
    (microsoft.public.sqlserver.replication)