Stored Procedure and Functions in Sql

Functions cannot "touch" any database but read them only. Stored procedures can do anything and everything with databases.

You cannot execute a stored procedure from a function.

You can execute an extended stored procedure from a function.