SQL Server 2005 CLR and XML Demos

home
database
view story

10 Kicks

SQL Server 2005 CLR and XML Demos(weblogs.asp.net)

submitted by RobChappel(2720) 5 years, 4 months ago

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: 22
Tweet

tags: SQL DanWahlin XML CLR another

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:

ashithmr(90) -

Harleyy(0) -

silverCORE(275) -

goal(0)

More who kicked this story...

Comments:

posted by RobChappel(2720) 5 years, 4 months ago 0

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 ColdChilli(55) 5 years, 4 months ago 0

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

Most Active Users

What's this?