|
|
-
|
|
Introduction The previous articles were focusing on TYPED XML and had been explaining how to generate an XML schema that can be used to validate the XML data. We have seen how to validate the existence of elements and attributes, how to validate data types and how to apply restrictions on the actua......
|
|
-
|
|
I was working on my presentation for 24-hour-pass event on 2nd September and came across the sorting issue with the solution explorer. I have a number of script demos and I wanted to organize them by name. No matter, what I did, the solution explorer continued to display the script files in its own ......
|
|
-
|
|
I just came across a task to extract ZIP code values from the address column of a table. The address is a single string that contains information such as street, city, state, zip code, apartment number etc. The data comes from a legacy system where the address information is not stored in separate c......
|
|
-
|
|
This post intends to help TSQL developers get started with PIVOT/CROSS TAB queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past.
Let us say for example we need a result set as foll......
|
|
-
|
|
IDENTITY columns are managed by SQL Server. Most of the times you would not dare to touch the values, except for reading them. However, there may be times when you really need to update/insert explicit values, instead of letting SQL Server generate a value for you.
How do I insert an explicit va......
|
|
-
|
|
I wrote this query a few months back to help some one in the XML forums. Here is the sample XML data for this lab. Names><br /> Name>Jacob</Name><br /> <span style="color: #00......
|
|
-
|
|
XML Data Type functions can be used to perform a number of string operations. This post explains how to parse a delimited string using the XML approach. The XML approach helps you to avoid the WHILE-LOOP that you might need with most other approaches. In one of my previous posts, I had pre......
|
|
-
|
|
XML Workshop - A series of XML articles published at www.sqlservercentral.com XML Workshop I - Generating XML with FOR XML - A short article that explains how to generate XML output with TSQL keyword FOR XML with AUTO and RAW directives XML Workshop II - Reading values from XML varia......
|
|
-
|
|
We have seen how to update the value of an attribute and how to delete an attribute from an XML variable. Let us now see how to insert an attribute to an XML variable. We could do this by using the modify() method of XML data type. Note that XQuery methods are case sensitive. The following......
|
|
-
|
|
This example has an XML document with a bit complex node structure. The XML document has 3 elements and each of those elements has several child elements. If you have a closer look into the XML structure you could see that, not all the child elements have same number of elements. Some of them are m......
|
|