Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Declare Xml
Configuring Service Broker Architecture – SQLServerCentral
Introduction The Service Broker framework provides a Transact-SQL interface for sending and receiving messages, combined with a set of guarantees for message delivery and processing. It guarantees that a program receives each message in a conversation exactly once in the order in which the message is sent, not the order in which the message enters the queue. Service Broker is designed around the basic functions of sending and receiving messages.
A Possible Alternative to SQL UNPIVOT – SQLServerCentral
Introduction There can be situations where you wish to convert columns into rows from an SQL result set. We will use the term "flattening" for this. If the results of a query yield 3 columns of results, we want to convert this to 3 rows of 2 columns (let's call these "name/value" pairs).
Asynchronous Procesing with Service Broker – SQLServerCentral
Introduction When I first heard of the mysterious service broker I was intrigued to find out what it was and what it could do. So I did some reading up and discovered it can play a part in building a range of enterprise solutions. One feature that generated a great deal of interest for me was the asynchronous stored procedures. When writing asynchronous architecture in the past I’ve had to use application languages to orchestrate asynchronous database operations.
Sending multiple rows to the Database from an Application: Part II – SQLServerCentral
We have all faced the problem while designing our applications using MS SQL Server 2005 where we want to send multiple rows to be modified (to be inserted or updated or deleted) to the database. We know how to return a set of rows from the database to the application, but we do not have any feature until SQL Server 2005 to send multiple rows to the database.
XML Workshop 25 - Inserting elements and attributes to an XML document – SQLServerCentral
Introduction In the previous session we examined the "delete" command supported by the "modify()" method of XML data type. In this session we will learn how to insert an element or attribute into an XML document using the XML data type method: modify(). Sample XML Document Here is the sample XML document that we will use for the examples in this session.
XML Workshop 24 - Modifying XML Documents Using XQuery Part 1 – SQLServerCentral
Introduction Most of the articles I presented in the XML Workshop were either generating XML documents or querying XML documents. An area that I have not touched in detail in this series of articles is modifying XML documents. I am dedicating this and the next few sessions to discuss various scenarios of modifying XML documents. Let us start with deleting elements and attributes from XML documents. We will then discuss INSERT operation and will see how to modify elements and attributes.
XML Workshop XXIII - A TSQL ATOM Library – SQLServerCentral
Introduction In the last few sessions of XML Workshop we had been looking at ways of generating RSS/ATOM Feeds. You can find the previous sessions here. We have seen how to generate RSS and ATOM feeds in SQL Server 2005 as well as 2000. In the previous sessions, we have seen how to generate RSS and ATOM feeds using FOR XML PATH as well as FOR XML EXPLICIT.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Declare
Contact Declare, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack