Peter Blignaut venblee

venblee / XML.sql

Created December 13, 2013 07:09

Select From XML

	@TestResults XML = Null


	CREATE TABLE #Test
	{
	TestId INT
	}

	INSERT INTO #Test(TestId)
	SELECT c.value ('@TestId[1]' , 'INT' ) AS TestId