Seth Delconte

Seth Delconte is a Microsoft Certified Trainer and Database Administrator. He currently works as a SQL Server Developer in the finance industry. In addition to SQL Server database development and administration, he enjoys dabbling in C#.NET and Linux development.

Articles: 2

Basic SQL Server XML Querying

We have XML data in a SQL Server database that we want to search efficiently, but are not sure of the best way to get the results we want. We need to find specific values in certain XML nodes- this will involve finding node values that match given substri

Seth Delconte
February 20, 2013

Examples of using XQuery to update XML Data in SQL Server

What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method,

Seth Delconte
August 2, 2012