SELECT only first element using XQuery

Below is the example of how to select only first element from whole bunch of XML in sql server.
declare @x xml;
SET @x='<Statuses>
<Status DateAndTime=””>
<one State=”” Desc=”” />
<two State=”” Desc=”” />
<three State=”” Desc=”” />
</Status>
<Status DateAndTime=””>
<four State=”” Desc=”” />
<five State=”” Desc=”” />
<six State=”” Desc=”” />
</Status>
</Statuses>’
SELECT @x.query(‘(Statuses/Status)[1]’)

declare @x xml;SET @x='<Statuses>        <Status DateAndTime=””>                 <one State=”” Desc=”” />                 <two State=”” Desc=”” />                 <three State=”” Desc=”” />        </Status>        <Status DateAndTime=””>                 <four State=”” Desc=”” />                 <five State=”” Desc=”” />                 <six State=”” Desc=”” />        </Status></Statuses>’
SELECT @x.query(‘(Statuses/Status)[1]’)

Advertisements

About Saad Khan

Saad is an ASP.NET developer with 4 years of experience, and has also made a number of contributions to the Sitefinity marketplace and community. He loves to explore new code, and create innovative tools and procedures while exploring new approaches in his work with Sitefinity and MVC. As an experienced .NET developer, he frequents both Telerik and Microsoft technologies. In his spare time, Saad is an avid gamer and movie fanatic, and also experiments with new and interesting tools on the Microsoft platform.​​

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: