Insert record

ALTER procedure [dbo].[InsertStudentrecord]
(
 @StudentFirstName varchar(200),
 @StudentLastName varchar(200),
 @StudentEmail varchar(50)
)
as
begin
 insert into tbl_Students (Firstname, lastname, Email)
 values(@StudentFirstName, @StudentLastName, @StudentEmail)
end

Tạo store procedure 1 tham số

create procedure [dbo].[Getstudentname]
(
 @studentid int -- input parameter, studentid of the student
)
as
begin
 select Firstname+' '+Lastname from tbl_Students where studentid = @studentid
end

Xóa Stored Procedure

DROP PROCEDURE [Tên Procedure]