Stored Procedure Tutorial

StudentID StudentName

2 Surya

3 Anil

4 Atulaya

5 Ananaya

 

Get Student with parameter

---------------------------

create procedure GetStudent

@StudentId int

As begin

select * from Students

where StudentId=@StudentId

end

exec GetStudent 4

GetStudentWithNoParameter

----------------------------------

create procedure GetStudentNoParameter

 

As begin

select * from Students

 

end

exec GetStudentNoParameter

exec GetStudent 2

UpdateStudent

-------------------

create procedure UpdateStudent

@StudentName varchar(400),

@studentId int

as begin

update Students Set StudentName=@StudentName where StudentId=@studentId

end

EXEC UpdateStudent @StudentName = 'Anil', @studentId = 3

InsertStudent

---------------------------------------

create procedure insertstudent

@StudentName varchar(20)

As begin

insert into Students (StudentName) Values(@StudentName)

end 

exec insertstudent 'Ansh'

Select * from Students

Delete Student

------------------------------------------

create procedure DeleteStudent

@StudentId int

As 

Begin

Delete from Students where StudentID=@StudentId

end

exec DeleteStudent 1002

StudentID StudentName

2 Surya

3 Anil

4 Atulaya

5 Ananaya

1003 Utkarsh

1004 Utkarsh

1005 Utkarsh

1006 Utkarsh

1007 Utkarsh

1008 Utkarsh

1009 Utkarsh

1010 Utkarsh

1011 Utkarsh

1012 Utkarsh

1013 Ansh