Each stored routine is associated with a particular database, just like a table or a view:
Stored procedures and functions do not share the same namespace. It is not possible to have two procedures or two functions with the same name in a database, but it is possible to have a procedure and a function with the same name in a database. |