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 |
| Aggregates |
