Your question, your audience. Choose who sees your identity—and your question—with question security.
ALTER PROCEDURE [dbo].[GetXmlData] @GuidOfInterest uniqueidentifier declare @XmlCol as xml; select @XmlCol = XmlTableCol from dbo.TableWithXmlCol where UniqueGuid = @GuidOfInterest select @XmlCol.value('(//Root/@RootName)', 'char(38)' ) as RootName, @XmlCol.value('(//Root/@RootGUID)', 'char(38)' ) as RootGuid, @XmlCol.value('(//Root/SetupName)', 'char(80)') as SetupName
Join the community of 500,000 technology professionals and ask your questions.