CREATE procedure [dbo].[searchOrg]
@depName varchar(20),
@FDepID int
as
begin
declare @str varchar(8000)
set @str='select DepartmentID,DepartmentName,FDepartmentID from OrganizationInfo where 1=1'
if (@depName!='')
set @str=@str+' and DepartmentName like ''%'+@depName+'%'''
if (@FDepID!=-1)
set @str=@str+' and FDepartmentID = '+rtrim(@FDepID)
exec(@str)
end
go
@depName varchar(20),
@FDepID int
as
begin
declare @str varchar(8000)
set @str='select DepartmentID,DepartmentName,FDepartmentID from OrganizationInfo where 1=1'
if (@depName!='')
set @str=@str+' and DepartmentName like ''%'+@depName+'%'''
if (@FDepID!=-1)
set @str=@str+' and FDepartmentID = '+rtrim(@FDepID)
exec(@str)
end
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货