SQL Server 2005 CLR and XML Demos

Why not join our community?, there are 3 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

10
kicks

kick it

SQL Server 2005 CLR and XML Demos

published 1 year, 11 months ago, submitted by RobChappel 1 year, 11 months ago

weblogs.asp.net — 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 | category:

Database | Views: 7 | Get KickIt image code

tags: SQL, XML, CLR, DanWahlin | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

RobChappel -

gavinjoyce - GreekTheNick - ASPrunner - dimmer - MarthaBass - goal - Harleyy - ashithmr - silverCORE

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

posted by RobChappel 1 year, 11 months ago

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

posted by ColdChilli 1 year, 10 months ago