NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > XML > XML Retrieve Element

Template Script: XML\XML Retrieve Element.sql

DECLARE @XML XML = ''

SELECT @XML.value(N'/data[1]/@DealCloseDt', N'date')
SELECT
sl.c.value(N'@DealCloseDt', N'date') AS DealCloseDt
FROM @XML.nodes(N'data') sl(c)

Description for Template Script: XML\XML Retrieve Element.sql

Todo