Store procedure has some similarities with views in the sense that it allows encapsulation. i.e. to retrieve for further, later use a series of commands, like the select command.
Create Procedure and Execute
Create Procedure and Return data based on Input
- You can't drop procedure and drop it again - (with same name)
- You can't create procedure and create it again - (with same name)