最近になってデータベースを使い始めた人や，「SQL Server 2005」の新機能をチェックしている人にとって，共通言語ランタイム（CLR）とSQL Server 2005の関係は，ちょっとした謎に感じられることだろう。今回はデータベース技術者が知っておくべきCLRとSQL Serverの関わり合いに関する事実を紹介する。

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

This is demo code how messages can be sent from Microsoft SQL Server (2005+) to a RabbitMQ message broker. The way it is implemented is by using SQLCLR, .NET running inside the SQL Server engine ...

Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure. The instance configuration clr enabled must be turned on, and it will be turned ...

T-SQL is great for database code, but writing procedural code in T-SQL has always been difficult. Invariably, your project includes a stored procedure or two, requiring some text parsing or complex ...

無料アプリをダウンロードして、毎日新しい背景で素晴らしい景色を楽しもう。