This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)
2013-12-28 (first published: 2013-12-10)
7,532 reads
T-SQL has some well known limitations when working with parameters for a stored procedure, not the least of which is a variable number of parameters. While there are some solutions, they can be cumbersome to work with. Sloan Holliday brings us a creative solution using XML that can solve many issues.
2006-02-28
12,073 reads
DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.
2005-11-22
11,007 reads
You kick off a distributed job expecting it to finish in minutes — but...
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Comments posted to this topic are about the item Representing Money
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Which types of currency does the money data type represent?
See possible answers