use pubs |
go |
if object_id(N'dbo.usp_getemployebyid') is not null |
begin |
drop proc dbo.USP_GetEmployeById; |
end |
go |
--=========================================================== |
-- Function : 按员工号获取员工信息 |
-- Author : Kerry |
-- Create Date : 2010-08-10 |
-- Description : |
---------------------------------------------- |
-- 2010-08-13 : 修改.......增加..... |
-- 2010-08-14 : 修改.......增加..... |
--=========================================================== |
create procedure dbo.USP_GetEmployeById |
@EmployeeID int = -1, |
@EmployeeName nvarchar(30) = null |
as |
set nocount on; |
begin |
if(@EmployeeID = -1 and @EmployeeName is null) |
begin |
print '请输入员工ID号或是用户名字'; |
end |
if @EmployeeID = -1 |
select * from dbo.Employee where fName = @EmployeeName; |
else |
select * from dbo.Employee where emp_id = @EmployeeID; |
end |
go |
引用:https://www.cnblogs.com/xugang/archive/2010/08/24/1807070.html