Parsing XML in SQL2005

DECLARE @docHandle int
DECLARE @xmlDocument nvarchar(max) -- or xml type
SET @xmlDocument = N'
ABC123
ABC1233232
'
EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument
-- Use OPENXML to provide rowset consisting of customer data.
--INSERT Customers

declare @Test nvarchar(10)
declare @Test2 nvarchar(10)

SELECT @Test=text
FROM OPENXML(@docHandle, N'/Parameters/Parameter[@name=''Test'']/text()')

SELECT @Test2=text
FROM OPENXML(@docHandle, N'/Parameters/Parameter[@name=''Test2'']/text()')

print @Test
print @Test2

-- WITH Customers
-- Use OPENXML to provide rowset consisting of order data.

Comments

Post a Comment

Popular posts from this blog

Data Modelling - Understanding Tools and Techniques Involved

Image
Table of Contents What is Data Modelling? Uses of Data Modelling Tools Three Perspectives of a Data Model Data Modelling Techniques Summing Up... What is Data Modelling? Data Modelling is the process of analyzing the data objects and their relationship to the other objects. It is used to analyze the data requirements that are required for the business processes. The data models are created for the data to be stored in a database. The Data Model's main focus is on what data is needed and how we have to organize data rather than what operations we have to perform. Uses of Data Modelling Tools Data Modelling is a process to formulate data in an information system in a structured format. Listed below are certain practical uses of the related tools in any sector or industry. Data Modelling helps create a robust design with a data model that can show an organization's entire data on the same platform. The data model makes sure that all the data objects required by the database are r...
Read more

WPF Questions

1. Triggers 2.Multivalue property convertor Dispatcher : dispatcher is a basic message dispatching system, with multiple prioritized queues. Examples of messages include raw input notifications (mouse moved), framework functions (layout), or user commands (execute this method). By deriving from  DispatcherObject , you create a CLR object that has STA behavior, and will be given a pointer to a dispatcher at creation time. DPI Settings INotifypropertychange Update Source Trigger Dynamin/Static Resource Difference WPF Architecture Style Based On Prism MVVM Bubbleing/Tunnelling Routed Event Command Visual Tree/Logical Tree
Read more

Installing multiple instance of product using wix

At my last job, I was responsible for build and install for a single tenant SaaS system that consisted of ASP.NET WebServices, WinUI and WebUI clients. This system lent itself to needing the ability to have different versions installed in parallel with different configuration options. At the time, InstallShield 12 had the ability to generate and embed product code changing multiple instance transforms but the bootstrapper lacked the ability to service these instances. As a result I authored a custom bootstrapper that interacted with the MSI API and simple reflection against the MSI database to connect the pieces into a solution that looked very much like InstallScripts multiple instance support. In fact I wrote about this on my blog: Multiple Instance MSI's and InstallShield 12 . This blog article has continued to be very popular among my visitors.
Read more