|
Comments
|
Hilary Cotter on
12/17/2008
Short to the point, and focused:)
|
|
|
Would have been helpful to have a bit more explanation of the syntax, especially for the xml WHERE clause.
|
|
|
Michael, the format of the video is too short to go into detailed discussion of using XML methods in predicates. If you are interested here is a good article that covers more details on the XML methods: http://msdn.microsoft.com/en-us/library/ms345117.aspx. Also, if you are interested, the following article covers more details on using appropriate XML indexes for those predicates: http://msdn.microsoft.com/en-us/library/ms345118.aspx.
|
|
|
excellent demo
|
|
|
I thought the query was going to say where the data element = 2, but it the query said = 1, I think I will need to watch it again to understand what is happening.
|
|
|
very good to the point with good example
|
|
|
The balloon flashed too quickly. Thanks for the example.
|
|
|
Team FAB, if you watch closely you will see inside the exist() method the value 2 is compared to the customer id, but the exist() method is checked for 1, because exist() returns 1 (true), 0 (false), or NULL.
|
|
|
Good video on XML data comparison, but it would have been nice if code was provided...
|
|
|
To add to this you can also do the following to help improve the code:
DECLARE @id int
SET @id = 2
--and have the WHERE clause be like this:
WHERE T.customer.exist('id/text()[. = sql:variable("@id")]') = 1;
check out link
http://msdn.microsoft.com/en-us/library/ms345118(SQL.90).aspx#sqloptxml_para
|
|
Steve Harris on
8/24/2009
Was complete in what it told you but very confusing on how parse XML data. More specifically, the strange formatting structure of using EXIST in the WHERE clause.
|
|
|
Steve,
Here is article with more details on the XQuery capabilities in SQL Server and more examples of using the Exist() method in the WHERE clause:
http://msdn.microsoft.com/en-us/library/ms345117(SQL.90).aspx
|
|
|
Excellent!
|
|
|
great!
|
|
|
the pop up explanation was a good enhancement
|
|
|
good
|
|
|
excellent, you mix sql and xpath langage in the where condition. Good
|
|
|
Could have explained the syntax a little more. It's pretty wierd code.
|
|
Jamshid Nouri on
11/8/2010
great short demo
|
|
Mark Hathaway on
11/8/2010
Need more XML insruction.
|
|
David Burnett on
11/8/2010
example was too simple and speakers pronounciation was hard to understand.
|
|
|
Informative video. Until now I didn't know that we can use xml data like this.
|
|
|
not sure what happens if reading from xml file though
|
|
|
Thanks.
|
|
|
om
|
|
|
Good job man. A tidy and simple example.
|
|
Kasey Wheeler on
11/9/2010
Nice video.
|
|
|
Great material but I think I need a primer on XML Query as this moved a bit fast for me.
|
|
|
The quality of video was not great. Something wrong with streaming. The information is valuable in any case.
|
|
|
This is really excellent article for the SQL Script and XML.
|
|
|
Presenter's accent a little hard to follow.
|
|
|
This one was over my head.
|
|
krishnaroopa on
11/23/2010
Good Example. I have requirement that where clause will be defined dynamically and I need to check whether the record exists.
eg: 'id/text()[. = "2"]' will be in a sql variable?
|
|
Plamen Ratchev on
11/24/2010
Krishnaroopa, yes you do need to use sql:variable to pass the value dynamically. Something like: exist('id/text()[. = sql:variable("@value")]') = 1
|
|
|
please post more videos on XML datattypes
|
|
|
please post more videos on XML datattypes
|
|
|
it would have been better if it included a more complex filter scenario
|
|
|
Hard to understand speaker
|
|
|
nice
|
|
|
Good article
|
|
|
good
|
|
|
Well-explained, simple example of querying using XML commands. Would like the author to provide more videos on this topic.
|
|
|
You are a great teacher! Thanks for posting.
|
|
|
nice video
|
|
Brian Savoie on
12/31/2011
XML parsing is hideous in tsql!! Thanks for the lesson.
|
|
|
GOOD
|
|
|
bad english
|