create procedure [dbo].[Getstudentname]
(
@studentid int -- input parameter, studentid of the student
)
as
begin
select Firstname+' '+Lastname from tbl_Students where studentid = @studentid
end
ALTER procedure [dbo].[GetstudentnameInOutputVariable] ( @studentid int, @studentname varchar(200) out ) as begin select @studentname = Firstname+' '+ Lastname from tbl_Students where studentid = @studentid end
ALTER procedure [dbo].[GetstudentnameInOutputVariable]
Trả lờiXóa(
@studentid int,
@studentname varchar(200) out
)
as
begin
select @studentname = Firstname+' '+ Lastname from tbl_Students where studentid = @studentid
end
ALTER procedure [dbo].[GetAllStudents]
Trả lờiXóaas
begin
select Studentid, Firstname, Lastname, Email
from tbl_Students
end