What is StoredProcedure

stored procedure is advanced feature in sql server that offers you to create,compile and run sql commands in the server itself.
There are many types of stored procedure availabe in Sql.
1)User-defined Stored Procedures
There are several advantages in writing our own stored procedures. We write complex and nested statements with less effort.
2)Extended Stored Procedures
Extended stored procedures are used to access SQL server by using dlls.
3)System Stored Procedures
System stored procedures are used for administrating, configuring and monitoring the SQL server.
Ex:-
select * from Emp
create procedure Empp @eusername nvarchar(20),@epassword nvarchar(20),@EEmpid nvarchar(20)
as
begin
insert into Emp (UserName,PassWord,EmpID) values(@eusername,@epassword,@EEmpid)
end

alter procedure EmpUpdate @eEmpID nvarchar(20),@eUserName nvarchar(20),@ePassword nvarchar(20)
as
begin
update Emp set PassWord=@ePassword,UserName=@eUserName where EmpID=@eEmpID
end
output:
-------
empp 'rajan','daran','1050'
empp 'ravi','ravi','890'
EmpUpdate 'gr','mahagr','anuja'