Referring to my previous post about How to implement user defined aggregates in SQL Server 2005 , I had a couple of emails about some problems when data size exceeds the 8KB which was a limit in SQL Server 2005. I forgot to mention this point in my previous...
Recently, I've been doing a lot of invoking .NET Assemblies within SQL Server 2005, I bloged an overview of SQLCLR here , also I posted about how to implement aggregation function in C# here . Actually invoking .NET code has many advantages but at...
I posted earlier an overview about the SQLCLR component of the SQL Server 2005, and showed how to implement a simple user-defined function using Visual Studio 2008 and C#, this post will show the importance of .NET Framework to SQLCLR by adding more functionality...
Introduction: SQL Server 2005 with it's built in T-SQL as well as SQL SERVER Management Studio are just amazing, you can build your database, create your own procedures, functions and triggers. You can also access data, process information and update...