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
Comments
Post a Comment