Step by Step stored procedure

A stored procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a proc, sproc, StoPro, or SP) are actually stored in the database data dictionary.

A stored procedure is a procedure (like a subprogram in a regular computing language) that is stored (in the database). Correctly speaking, MySQL supports "routines" and there are two kinds of routines: stored procedures which you call, or functions whose return values you use in other SQL statements the same way that you use pre-installed MySQL functions like pi(). I'll use the word "stored procedures" more frequently than "routines" because it's what we've used in the past, and what people expect us to use.


Step by step procedure to create a stored procedure
Step-1
Open Microsoft sqlserver
Login into that

Step-2

Select new query or any one below of that

Step-3

Write a procedure as shown here

&

Execute that query as shown here

Step-5
Hear you can see that stored procedure

See Status of the blog