هدية مجمعة وظائف مهمه

السلام عليكم ورحمة الله وبركاته

هدية صغيره

1-if

2-format set val -- 0001 0012 0125

3-formatdate dd/mm/yyyy or mm/dd/yyyy

4-ColToRow

CREATE FUNCTION [dbo].[udfIIF] (@value nvarchar(100) , @valueToCompare nvarchar(100) , @TrueValue nvarchar(100) , @FalseValue nvarchar(100))
RETURNS nvarchar(100)  AS  
BEGIN 
Declare @retValue nvarchar(100)
Set @retValue=@FalseValue
If @Value=@valueToCompare Set @retValue=@TrueValue
Return @retValue
END
-----------------------------------
CREATE FUNCTION dbo.udfFormat (@val1 nvarchar(100), @val2 nvarchar(100))
RETURNS nvarchar(100)
AS
BEGIN 
RETURN (substring(@val2,0,len(@val2)-len(@val1)+1) + @val1)
END 
-----------------------------------
CREATE FUNCTION [dbo].[udfFormatDate] (@dDate  datetime,@cChar char)
RETURNS nvarchar(100)  AS 
BEGIN 
Declare @retValue nvarchar(100) 
Set @retValue=month(@dDate) + substring(@cChar,2,1)+day(@dDate) +substring(@cChar,5,5)
if substring(@cChar,0,2)='DD'  Set @retValue=day(@dDate) + substring(@cChar,2,1)+month(@dDate) +substring(@cChar,5,5)
Return @retValue
END
-----------------------------------
CREATE function [dbo].[udfcol2row] (@nValue int) 
returns varchar(2000) as 
begin
DECLARE @psCourseContentSubName varchar(200),  @sName varchar(800)
DECLARE course CURSOR FOR 
SELECT psCourseContentSubName FROM vCourseContentSubName where ptnActionCourseContentCode=@nValue 
OPEN course
FETCH NEXT FROM course 
INTO  @psCourseContentSubName
set @sName=''
WHILE @@FETCH_STATUS = 0
BEGIN

set @sName=@sName+@psCourseContentSubName+'-'

   FETCH NEXT FROM course 
   INTO  @psCourseContentSubName
END

CLOSE course
DEALLOCATE course
return  @sName
end

اي خدمة