SQL Server Custom Functions

CREATE function [dbo].[F_testfunc](     @v_id nvarchar(4000)    ,@v_type nvarchar(4000) )    returns NVARCHAR(4000) asbegin    Declare @str_res NVARCHAR(4000); Declare @str_id NVARCHAR(4000); Declare @str_code NVARCHAR(4000); Declare @str_name NVARCHAR(4000); SELECT @str_id =a.ID,@str_code =A.event_code,@str_name =A.event_name fromApp_event aWHEREa.ID= @v_id; IF(@v_type='ID')      RETURN @str_id    IF(@v_type='Code')      RETURN @str_code     IF(@v_type='name')      RETURN @str_name           return @str_name;EndGO

SQL Server Custom Functions