ALTER FUNCTION [dbo].[FUN_DepName] ( @Code varchar(20), //参数 @type int ) RETURNS varchar(50) //返回值类型 AS BEGIN DECLARE @Name varchar(50) if(@type=1) begin SET @Name =(SELECT DeptName FROM BaseDeptInfo WHERE DeptCode = @Code )//执行的sql end if(@type=2) begin SET @Name =(SELECT DeptName FROM BaseDeptInfo WHERE ZJM = @Code ) end RETURN @Name END