What is an extended stored procedure in SQL Server?

What is an extended stored procedure in SQL Server?

- An extended stored procedure compiles as DLL and are created to expand capabilities of user defined stored procedure.
- It uses xp_ prefix as naming convention.
- It allows you to create your own external routines in a programming language such as C.
- It appears to users as normal stored procedures and executed in the same way.
- Extended stored procedure return results and return status.
What are triggers in SQL Server?
Triggers are special kind of event driven stored procedures. Executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.......
What is a self join in SQL Server?
Two instances of the same table will be joined in the query........
Difference between UNION ALL and UNION
UNION statement eliminates duplicate rows whereas UNION ALL statement includes duplicate rows........
Post your comment