question

MHafiez avatar image
MHafiez asked

XML column

Hello,

how do I create a SQL script to query this XML Column output?

<DeploymentReport xmlns="http://schemas.microsoft.com/sqlserver/dac/DeployReport/2012/02">; <Alerts /> <Operations> <Operation Name="Create"> <Item Value="[dbo].[Index_Usage_Unused]" Type="SqlTable" /> <Item Value="[dbo].[IndexProperty]" Type="SqlTable" /> <Item Value="[dbo].[Table_Inventory_All_CheckConstraint]" Type="SqlTable" /> <Item Value="[dbo].[WhoIsActive].[cx_collection_time]" Type="SqlIndex" /> <Item Value="unnamed constraint on [dbo].[CCExecutionCount]" Type="SqlDefaultConstraint" /> <Item Value="unnamed constraint on [dbo].[DroppedObjects]" Type="SqlDefaultConstraint" /> <Item Value="Full-text Index on [dbo].[Query_Usage]" Type="SqlFullTextIndex" /> <Item Value="[dbo].[Backup_Report_Status]" Type="SqlProcedure" /> <Item Value="[dbo].[CommandExecute]" Type="SqlProcedure" /> </Operation> </Operations> </DeploymentReport>

sql-server-2012xml
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.