Syntax:
Create procedure procedure_Name
select Columns
from table name
where clause
Example:
- create procedure prcstd
- select Ename, EDesignation
- from Employee
- where Eid = txtEid.Text
- Example
- for stored procedure with parameter: create procedure procedure_Name
- @p1 int
- as
- select EName, Edesignation
- from Employee where Eid = @p1
- end