Is it possible to pass a DataSet to SQL and process the data in a SQLCLR stored procedure? This is the question I set out to answer. The .NET Framework 2.0 adds some features to the DataSet that make this scenario possible (WriteXml, ReadXml). I created
Read More...
In response to a newsgroup post, I wrote this quick little tutorial. This tutorial assumes you have the AdventureWorks database installed, but any database will do. 1. Create SQL Server Project in Visual Studio 2. Add a connection to AdventureWorks database
Read More...
Some background is probably in order. I'm a Software Tester here at Microsoft. I work in the Integration Test Team, Release Release Services, SQL Server. One of my new jobs is to look at how our products integrate. Currently I'm investigating SQL Server
Read More...
