Number | Base of Difference | CLR Integration | Extended Stored Procedures |
1 | Version | This will not support the older versions of SQL Server and supports starts from version SQL 2005. | And when we say about the Extended Stored Procedures this will supports all the version of SQL Server. |
2 | Programming Language | Here when we say about the programming language in CLR Integration it is written in .NET programming language. | When we say about the programming languages it is written in C/C++. |
3 | Integrity | When we say about the CLR Integrations this will not compromise the integrity of the SQL server process. | When we say about the Extended Stored Procedure this will compromises the integrity of the SQl Server process. |
4 | Logic | When we say about the CLR Integrations this will provides an alternative method to writing codes simply. Logic is expressed in the form of table-valued functions. | When we say about the Extended Stored Procedures here developers need to write server-side logic that is complex in a way |
5 | Definition | When we say about the CLR Integration here CLR will provides managed code with different services like cross-language integration, object lifetime management, code access security, and debugging and profiling support. | When we say about the Extended Stored Procedure they support the functionalities that cannot work with T-SQL stored procedures.
|