| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
 |
||
Using xml attribute in the where clause of a slect statement.
|
||
| Tags: |
 |
|
|
LinkBack | Thread Tools | Display Modes |
10-17-2008, 07:24 PM
|
|||
|
|||
Using xml attribute in the where clause of a slect statement.
I have the following select/insert statement: insert into [News].[NewsArchive] select [Article], [LastModified] from [News].[News] where ... In the where clause, I need to use the value of the attribute /NewsArticle/@Date in an xpath statement. How do you do this? 
|
| Sponsored Links |
|
10-18-2008, 01:45 PM
|
|||
|
|||
|
Re: Using xml attribute in the where clause of a slect statement.
Andy B wrote:
> I have the following select/insert statement: > > insert into [News].[NewsArchive] select [Article], [LastModified] from > [News].[News] where ... > > In the where clause, I need to use the value of the attribute > /NewsArticle/@Date in an xpath statement. How do you do this? Example WHERE xmlColumnName.value('(/NewsArticle/@Date)[1]', 'datetime') = '2008-10-18T12:00:00' That assumes (based on the attribute name) that the Date attribute contains a date/time value that you want to cast to an SQL Server datetime value for instance. -- Martin Honnen --- MVP XML http://JavaScript.FAQTs.com/
|
|
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
© Camley Interactive (camley.info) 2008 - all logos and images are copywrite their respective owners.
Proud member of the Camley Interactive Network
Proud member of the Camley Interactive Network
|
Powered by vBulletin® Version 3.6.8 Copyright ©2000 - 2009, Jelsoft Enterprises Ltd. Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc. |
All times are GMT. The time now is 12:05 PM. Style Developed by Epic Designz |
