Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to search with SQLXML?

  
   Database Forums (Home) -> XML RSS
Next:  Connecting to MSDE named instance  
Author Message
Alejandro

External


Since: Oct 03, 2005
Posts: 3



(Msg. 1) Posted: Mon Oct 03, 2005 9:14 am
Post subject: How to search with SQLXML?
Archived from groups: microsoft>public>sqlserver>xml (more info?)
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

 >> Stay informed about: How to search with SQLXML? 
Back to top
Login to vote
Bertan ARI MSFT

External


Since: Sep 21, 2004
Posts: 56



(Msg. 2) Posted: Mon Oct 03, 2005 3:04 pm
Post subject: Re: How to search with SQLXML? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" wrote in message

>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
>

 >> Stay informed about: How to search with SQLXML? 
Back to top
Login to vote
Alejandro

External


Since: Oct 03, 2005
Posts: 3



(Msg. 3) Posted: Tue Oct 04, 2005 4:22 am
Post subject: Re: How to search with SQLXML? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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
 >> Stay informed about: How to search with SQLXML? 
Back to top
Login to vote
Bertan ARI MSFT

External


Since: Sep 21, 2004
Posts: 56



(Msg. 4) Posted: Thu Oct 06, 2005 6:40 pm
Post subject: Re: How to search with SQLXML? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" wrote in message

>
> 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
>
 >> Stay informed about: How to search with SQLXML? 
Back to top
Login to vote
Alejandro

External


Since: Oct 03, 2005
Posts: 3



(Msg. 5) Posted: Tue Oct 11, 2005 2:11 pm
Post subject: Re: How to search with SQLXML? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thank you Bertran for your help, I'm working now in this kind of
addendum in our DAL.

Alejandro
 >> Stay informed about: How to search with SQLXML? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
2000 = SQLXML 2005 = ??? (what is SQLXML replaced with in .. - Does anyone know what to use now instead of SQLXML to simply output XML over HTTP? I don't need any WSDL at this stage although it would be nice, just after outputting XML directly from the server over HTTP. Any suggestions and or tutorials would be muc...

SQLXML and XSL and VB.NET - I can find an example on how I call a stored proc and return XML and attach a stylesheet to it and render the HTML to the page using vb.net. I would like to display reports this way. If there is a simpler way to do the same thing let me know. I'm open to...

SQLXML Version - Hi, How can I determine the version of SQLXML installed on my server? Thank you, Alan

SQLXML 4.0 Beta (2005) - Folks: I thought I would try the .NET framework 2.0 beta version of SQLXML.4.0 and am running into a problem. When I add a project reference to Microsoft.Data.SqlXml in Visual Studio .NET Beta 2, I cannot compile the project. I get the "Are you mi...

SQLXML for xml explicit - Hi ppl, I am a newbie,a rookie in to the database world.I've got my first job now in a small company who couldnt offord a full fledged DBA. We have a requirement in which we need to query a lot of tables and form numerous XML with those data. I..
   Database Forums (Home) -> XML All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]