sqlserver函数简单介绍

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