Saturday August 1st

Friday July 31st

Thursday July 30th

Wednesday July 29th

SQL Server 2005 CLR and XML Demos

SQL Server 2005 provides many new features that can substantially enhance developer productivity and make it easy to perform tasks that used to be difficult in previous versions. Dan Wahlin provides us with a sample VS.NET 2005 database project that demonstrates how CLR functionality can be used in the database.

2 comments

The sample includes:

* Using the XML data type to store RSS feeds
* Querying XML fields using XQuery with FLOWR statements
* Converting XML data into a resultset using the new CROSS APPLY syntax
* Using the new TRY/CATCH syntax
* Creating stored procedures using C# (shows using SqlContext as well as SqlMetaData and SqlDataRecord classes)
* Creating custom functions using C#
* Creating custom aggregates to convert deliminated data into a resultset (and vice-versa)
* Performing dynamic pivots using the new PIVOT keyword with a custom aggregate

I have yet to find a good reason to store XML in the database, rather than breaking it down to true database tables.

Commenting on Stories is limited for now and will open up to those recommended by the community. Learn how
Loading DotNetKicks...
brought to you by the Kicks Network