Database Unit Testing

Database unit testing is an important part of any database development cycle. In this article, we demonstrated how to create a database unit test case using NUnit framework, C# and LINQ.

Explore XML Data Type in SQL Server

Beginning with SQL Server 2005, SQL Server provides extensive support for XML data processing. XML is now a native data type and methods like nodes() and values() can be used to convert XML into a relational table. The easy conversion from XML to a relational table provides a way for set-based updates based on user input. This article shows two examples.