MS SQL XML - How to search with SQLXML?

Author

How to search with SQLXML?

Alejandro

2005-10-27, 9:25 am

I have been looking for a solution in order to be able to search in our
Sql server 2005 (v.9.00.1116.00) using SQLXML and Schemas. Actually we
haven't found any kind of search, but complete only. For instance:

cmd.CommandText = "/Member[Member_Name = 'Lucie']" (copied from other
message)

Have anyone idea if Microsoft has solved this feature?

Should I start using templates as solution?

Thanks

Alejandro

Bertan ARI [MSFT]

2005-10-27, 9:25 am

Do you want to perform a query or a search over the databases in Sql Server
2005?

SqlXml only allows executing xpath queries over xml views. You may want to
look at the Full Text Search feature of Sql Server 2005 to peform a search
on Sql Server 2005.

--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"Alejandro" <avalles@knowledgesf.com> wrote in message
news:1128356068.975579.226660@o13g2000cwo.googlegroups.com...
>I have been looking for a solution in order to be able to search in our
> Sql server 2005 (v.9.00.1116.00) using SQLXML and Schemas. Actually we
> haven't found any kind of search, but complete only. For instance:
>
> cmd.CommandText = "/Member[Member_Name = 'Lucie']" (copied from other
> message)
>
> Have anyone idea if Microsoft has solved this feature?
>
> Should I start using templates as solution?
>
> Thanks
>
> Alejandro
>

Alejandro

2005-10-27, 9:25 am

Bertan ARI [MSFT] wrote:
> Do you want to perform a query or a search over the databases in Sql Server
> 2005?

I'm using xml views in my dataAccess layer, over standard relational
databases (old fashion DB, I'm not using xml columns) and I need to
search in a like-fashion with XPath, for instance, (customername LIKE
'jhon')

> SqlXml only allows executing xpath queries over xml views. You may want to
> look at the Full Text Search feature of Sql Server 2005 to peform a search
> on Sql Server 2005.

I've been looking at the FTS feature, but I didn't find anything
related between FTS and SQLXML. Do you know if this feature
(like-fashion search) 'is/will be' available in the 'near/never will
come' future? Is there a solution for this kind of search?

Thanks
Alejandro

Bertan ARI [MSFT]

2005-10-27, 9:25 am

Unfortunately, SqlXml does not offer the functionality you are looking for
and as you stated FTS and SqlXml do not colloborate.

On the other hand, you may use For Xml Explicit where you can construct
queries with "Like" clauses.
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.

"Alejandro" <avalles@knowledgesf.com> wrote in message
news:1128424950.277547.306530@g44g2000cwa.googlegroups.com...
>
> Bertan ARI [MSFT] wrote:
>
> I'm using xml views in my dataAccess layer, over standard relational
> databases (old fashion DB, I'm not using xml columns) and I need to
> search in a like-fashion with XPath, for instance, (customername LIKE
> 'jhon')
>
>
> I've been looking at the FTS feature, but I didn't find anything
> related between FTS and SQLXML. Do you know if this feature
> (like-fashion search) 'is/will be' available in the 'near/never will
> come' future? Is there a solution for this kind of search?
>
> Thanks
> Alejandro
>

Alejandro

2005-10-27, 9:25 am

Thank you Bertran for your help, I'm working now in this kind of
addendum in our DAL.

Alejandro

Sponsored Links