Working with sql xml | Sql server

Here is a code for manipulating XML object under SQL Server.
This code allow to recieve attribute and note contents.
Best for xml manipulations.

--Under this configuration:

DECLARE @xml XML
SET @xml = '<root><a><b id="456"></b><c>world...</c></a></root>'

--Get attribute's content from xml field:

SELECT @xml.value('(//root/a/b/@id)[1]','int') AS 'Attribute Content'

--Get node's content from xml field:

SELECT @xml.value('(//root/a/c)[1]','nvarchar(MAX)') AS 'Node Content'