What is an Extended Stored Procedure in MS SQL Server?

exdqitrt  于 2023-05-21  发布在  SQL Server
关注(0)|答案(2)|浏览(119)

What is an extended stored procedure in SQL Server?

trnvg8h3

trnvg8h31#

Extended stored procedures are stored procedures that call functions from DLL files. You can read the article How to use extended stored procedures to learn more.

However, extended stored procedures are deprecated and you should avoid using them if possible. CLR Integration should be used instead.

bxjv4tth

bxjv4tth2#

They reside inside the master database, you can use the command "sp_helpextendedproc", in respective database.

See below screen shot:

相关问题