1. Generally, stored procedures are the blocks of codes that can be accessed by simple application calls.
  2. At the same time, extended stored procedures help expand the functionality of SQL servers through external functions written in C or C++ languages.
Riya Answered question December 19, 2023
User Avatar

To maximize code reuse and user-defined operations, user-defined stored procedures are implemented using Transact-SQL (T-SQL) statements or the. NET framework Common Language Runtime (CLR). Database developers can write reusable code in languages like C using extended stored procedures.