Jacob's Blog

Having huge amounts of traffic can be a problem. Aside from the usual maintenance, you also need to check on the server load. Having a virtual dedicated server hosting can solve these problems.

December 2007 - Posts

SQL Server 2005 Replication - Adding two articles with same name in different schemas

I came across a very strange problem recently while creating a publication. I had objects with the same name but in different schemas. For example, "dbo.Invoices", "Billing.Invoices", "AR.Invoices" and "AP.Invoices"...

by Jacob Sebastian on 12-30-2007 | 1,051 Views

XML Workshops

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...

by Jacob Sebastian on 12-19-2007 | 24,632 Views

Another XML Shaping Example - using FOR XML PATH and EXPLICIT

In many of the previous posts, we discussed about controlling the structure of the XML being generated with FOR XML. SQL Server 2005 introduced the PATH operator which provides a great extend of control over the shaping of the XML being generated. With...

by Jacob Sebastian on 12-14-2007 | 2,815 Views

FOR XML EXPLICIT Tutorial – Part 3

Continued from FOR XML EXPLICIT Tutorial - Part 2 Having fixed the problem with the sort order, let us go ahead with the rest of the code. Let us add Addresses under the AddressCollection node and come up with the final version of the code. We need to...

by Jacob Sebastian on 12-14-2007 | 5,724 Views

FOR XML EXPLICIT Tutorial - Part 2

Continued from FOR XML EXPLICIT Tutorial- Part 1 Let us move ahead. Under each agent, we need a node named AddressCollection . Let us add the code for that. SELECT 1 AS Tag, NULL AS Parent, NULL AS 'Agents!1!' , NULL AS 'Agent!2!AgentID'...

by Jacob Sebastian on 12-14-2007 | 7,213 Views

Passing a Data Table to a SQL Server 2005 Stored Procedure

One of the readers at SQLServerCentral forum asked me about passing a DataTable to a stored procedure. He wanted to get an XML representation of the DataTable and then pass it to the stored procedure. I tried to answer the question and came up with a...

by Jacob Sebastian on 12-09-2007 | 3,521 Views