sql2008函数传入数据如果是N01返回A01否则返回A02

USE [NY_DB]
GO
/****** Object:  UserDefinedFunction [dbo].[Get_Nat_Cd]    Script Date: 11/09/2013 14:11:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  suhe
-- Create date:
-- Description: KR,CN
-- =============================================

ALTER FUNCTION  [dbo].[Get_Nat_Cd](@nat_cd varchar(10))
returns varchar(10)
as
BEGIN
declare @nat varchar(10)
if
@nat_cd='N01'
set  @nat='A01'
else
set  @nat='A02'
return @nat
END

 

调用

select  emp_no,ny_db.dbo.[Get_Nat_Cd](nat_cd) as nat_cd  into  hra100a01 from ny_db.dbo.epaa100t