Link: http://nielsb.wordpress.com/sqlclrproject/sqlclrdl/
Feature | SQLCLRProject | Built-in |
---|---|---|
Specific VS project type and item templates | Yes | Yes |
Automatic deployment of assemblies and creation of T-SQL objects | Yes | Yes |
Debugging support objects | Yes | Yes |
Automatic creation of T-SQL deployment scripts | Yes | - |
Automatic creation of T-SQL DML scripts for testing of the created objects | Yes | - |
Create objects in a non-default schema | Yes | - |
Define parameters in the .NET methods to have default values in T-SQL | Yes | - |
Define parameters in .NET to be created with different names in T-SQL | Yes | - |
Redeploying an UDT without manually dropping tables/columns depending on the UDT | Yes | - |