How to work with SQLCLR

SQL Server supports several types of objects that can be developed using .NET. The following table shows all of the object types that could be created using C# or other .NET languages:

Object Type Created using T-SQL Created using .NET
Stored procedure Usually created, typical object for any data manipulation Rarely created, that is, when results have to be saved into files
Trigger Usually created, and a supporting object, that is, for data denormalization Rarely created
Function Usually created when it's data-bound Rarely created, typically when string manipulation or complicated calculations that are less data-bound are required
Data Type Alias data types only Our own complex data types

Get Hands-On Data Science with SQL Server 2017 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.