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,346 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
11,901 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
10,869 reads
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
By Rob Sewell
A website can change the world. If you're a student, we'd like to help...
By Rob Sewell
The partner directory connects your agency with new customers.
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers