Extending SQL Server the New Way—CLR Integration
SQL Server 2005 introduces a new way to allow developers to extend the power of SQL Server—by integrating the CLR.
Now when you’re faced with a task you need to accomplish for which either T-SQL or the native SQL Server data types are ill-equipped, you can write code in your .NET language of choice to tackle that task. Need a new aggregate function? Write one using the .NET Framework. Need a stored procedure that performs mathematical computations? Write one using the .NET Framework. Need to store data in a data type that SQL Server is not natively equipped to handle? Create one using the .NET Framework. Need to write a user-defined function or a trigger that goes beyond T-SQL’s capabilities? You ...
Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
