CREATE PROCEDURE ProcInsertEmp
AS
insert into Employees(lastName,firstName)
values('Jack','Lee')
GO
----------------------------------
CREATE PROCEDURE ProcInsertEmp
@lastName varchar(10),@firstName varchar(10)
AS
insert into Employees(lastName,firstName)
values(@lastName,@firstName)
GO
-----------------------------------
CREATE PROCEDURE ProcQueryEmpById
@empId int,@lastName varchar(10) output
as
select @lastName=lastName from Employees
Where employeeID=@empId
GO
-----------------------------------
CREATE PROCEDURE ProcQueryEmpById2
@empId int
as
if exists(select * from Employees
Where employeeID=@empId)
begin
return 1
end
else
begin
return 0
end
GO