1#@!#!123s

��JFIF�� 1#@!#!123s
: C: / Inetpub / vhosts / tmvalve.com / httpdocs / Database /
Filename : Function.sql
back
--------------------------------------
------ Get Current Datetime ----------
----------- 21/12/2017 ---------------
--------------------------------------
CREATE FUNCTION dbo.get_date()
RETURNS DATETIME
AS
BEGIN
    DECLARE @date DATETIME;

    -- Get UTC time and add 5 hours 30 minutes for IST
    SET @date = DATEADD(MINUTE, 330, GETUTCDATE());

    RETURN @date;
END



--------------------------------------
------ Get Server Url ----------------
--------------------------------------
create function dbo.get_server_path()
returns varchar(100)
begin
	declare @server varchar(100)
	set @server=(select 'http://shreelgec.sofratechnology.com/')
	return @server
end



------------------------------
------ Split String ----------
------------------------------
create FUNCTION SplitString
(    
    @Input NVARCHAR(MAX),
    @Character CHAR(1)
)
RETURNS @Output TABLE (
	[index] int,
    Item NVARCHAR(1000)
)
AS
BEGIN
    DECLARE @StartIndex INT, @EndIndex INT
 
    SET @StartIndex = 1
    --IF SUBSTRING(@Input, LEN(@Input) - 1, LEN(@Input)) <> @Character
    --BEGIN
    --    SET @Input = @Input + @Character
    --END
	declare @index int = 1
    WHILE CHARINDEX(@Character, @Input) > 0
    BEGIN
        SET @EndIndex = CHARINDEX(@Character, @Input)
         
        INSERT INTO @Output([index],Item)
        SELECT @index,SUBSTRING(@Input, @StartIndex, @EndIndex - 1)
        
		set @index=@index+1
        SET @Input = SUBSTRING(@Input, @EndIndex + 1, LEN(@Input))
    END
 
    RETURN
END
GO