34,594
社区成员
发帖
与我相关
我的任务
分享
create procedure udsp_SelectDepartmentRecordContent
@Name nvarchar(16),
@SuperiorDeptName nvarchar(16)
as
declare @sql nvarchar(4000)
set @sql=N'select * from udfdt_Department where 1=1
'+N'case when @name is not null then N'and name=@oid else N'' END
'+N' CASE WHEN @SuperiorDeptName IS NOT NULL THEN N' AND SuperiorDeptName=@SuperiorDeptName' ELSE N'' end
exec(@sql)
create proc p1
@a int,
@b varchar(10),
@c int
as
begin
select * from tb where fa=isnull(@a,fa) and fb like '%' + isnull(@b,fb) + '%' and fc = isnull(@c,fc)
end