SiSense BI Evolved
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Jacob's Blog

Recent Blog Posts

Most Viewed

Archive

March 2009 - Posts

Practical SQL Server XML: Part Three

This is the third part of the XML blog series which intends to demonstrate some practical usages of the XML support extended by SQL Server 2005 and 2008. SQL Server MVP Pinal Dave wrote the first post in this series at http://blog.sqlauthority.com/2009...
by JacobSebastian on 03-17-2009 | 211 Views

SQL Server XSD - Typed XML and SCHEMA Collections

Introduction SQL Server 2005 supports two flavors of XML, namely TYPED and UNTYPED. A TYPED XML column or variable is bound to an XML schema which defines the structure of the XML that the variable or column can store. An UNTYPED XML variable or column...
by Jacob Sebastian on 03-15-2009 | 386 Views

SQL Server XSD - Creating variable content containers

Introduction There are times when we need to allow data with different XML structures. Let us take an example. Assume that we are working on a billing application and we need to store the payment details. Our application supports the following payment...
by Jacob Sebastian on 03-14-2009 | 102 Views

SQL Server XSD - Mixed Types

Introduction XML is getting widely accepted as the format for data exchange. Wide adoption of architectures like SOA (Service Oriented Architecture) contributed to the growth of applications and services that talk to each other and exchange data in XML...
by Jacob Sebastian on 03-13-2009 | 215 Views

SQL Server XSD - Custom Types and Inheritance

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...
by Jacob Sebastian on 03-11-2009 | 166 Views

SQL Server XSD - Validating values with SCHEMA

Introduction In the previous article we have seen how to work with TYPED XML and XML SCHEMAs. By using a TYPED XML which is bound to an XML SCHEMA, you can make sure that the value being stored to your XML column or variable is EXACTLY as per the format...
by Jacob Sebastian on 03-10-2009 | 331 Views

SQL Server IDENTITY Columns

I have written over a dozen articles covering almost all aspects of SQL Server IDENTITY columns. The intention of this page is to serve as an index, so that people can find the right post based on the specific piece of information they are looking for...
by Jacob Sebastian on 03-09-2009 | 125 Views

SQL Server IDENTITY Columns - A few more interesting facts

This is my 14th article on SQL Server IDENTITY values. In each post we discussed a couple of interesting points related to the IDENTITY columns. I saw a number of IDENITY related questions in various online SQL Server forums and saw a lot of cases where...
by Jacob Sebastian on 03-08-2009 | 183 Views

How to convert a number to a comma-formatted string?

Every time some one asked this question in the past, I used to suggest that formatting should be done at the presentation layer. While some of you might agree with me on this, I just wanted to point out that you can do comma formatting of numeric values...
by Jacob Sebastian on 03-03-2009 | 78 Views

XQuery Lab 43 - Deleting multiple elements

In XQuery Lab 18 , we saw how to delete an element from an XML variable or column. Let us now see, how to delete more than one element from an XML column or variable. Here is the sample XML that we will examine in this lab. < Employees > < Employee...
by Jacob Sebastian on 03-01-2009 | 772 Views

Copyright © Beyondrelational.com