Difference Between Stored Procedures and Extended Stored Procedures

Question

What is the main difference between SQL Server stored procedures (sp_) and extended stored procedures (xp_)? Why, in any case, are there extended procedures?

Answer 1

Extended stored procedures are written in c / C ++ (I believe that everything a DLL can create in native code), stored procedures are written in T-SQL

extended stored procedures exist because they allow you to do what you cannot do in T-SQL, for example, by running the DOS command (xp_cmdshell)

BTW procs, sp _.. ... . SP_

Answer 2

, SQL. , ++.