There are seven types of Transact-SQL stored procedures:
User-defined
System
CLR(.NET)
Extended
Temporary
Global temporary
Remote