Remove All New Line & (Feed) From A Variable Or Column In Sql Server

DECLARE @VARIABLE VARCHAR(MAX)=''

SET @VARIABLE= 'Hello Friend 
Thank You So Much For Visit My Blog 
Priyank Gadhiya '

SELECT REPLACE(REPLACE(@VARIABLE, CHAR(13), ''), CHAR(10), '')

Range Between Two Columns Validation Sql Server

DECLARE @FROMVALUE DECIMAL(15,3)=''  
DECLARE @TOVALUE DECIMAL(15,3)=''  
DECLARE @MESSAGE VARCHAR(MAX)=''  

IF  EXISTS(SELECT * FROM dbo.YOURTABLENAME AS C WHERE (C.F_VALUE <= @FROMVALUE AND C.T_VALUE >= @TOVALUE) OR ( (C.F_VALUE BETWEEN @FROMVALUE AND @TOVALUE ) AND (C.T_VALUE BETWEEN @FROMVALUE AND @TOVALUE))
)
BEGIN
SELECT @Message = 'Sorry !! Your Criteria Already Added !!'
RAISERROR (@Message, 16, 1);
END 

Script To All Few Days Modified Stored Procedure In Sql Server

DECLARE @PROCEDURENAME VARCHAR(255)
DECLARE @PROCEDUREID INT
DECLARE @TEXT VARCHAR(MAX)
DECLARE @GRANT_CMD VARCHAR(100)
DECLARE @GRANT_LEVEL VARCHAR(100)
DECLARE @GRANT_ROLE VARCHAR(200)
DECLARE @FILTER_DATE DATETIME = DATEADD(dd, -1, GETDATE())


DECLARE PROC_CURSOR CURSOR FOR

SELECT NAME,OBJECT_ID
FROM SYS.OBJECTS
WHERE TYPE = 'P'AND 
MODIFY_DATE >= @FILTER_DATE
ORDER BY MODIFY_DATE DESC

OPEN PROC_CURSOR
FETCH NEXT FROM PROC_CURSOR INTO @PROCEDURENAME,@PROCEDUREID
WHILE @@FETCH_STATUS = 0
BEGIN

SELECT @TEXT=SM.DEFINITION
FROM SYS.SQL_MODULES AS SM
JOIN SYS.OBJECTS AS O ON SM.OBJECT_ID = O.OBJECT_ID
WHERE O.TYPE='P'
AND OBJECT_NAME(SM.OBJECT_ID) = @PROCEDURENAME
PRINT '---------------------------- START PROC ( ' + @PROCEDURENAME + ' ) DATE ' + CONVERT(CHAR(10),@FILTER_DATE,126) +' ---------------------------'
PRINT 'IF EXISTS (SELECT * FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N''[DBO].[' + @PROCEDURENAME + ']'') AND TYPE IN (N''P'', N''PC''))'
PRINT 'BEGIN' + CHAR(13) + CHAR(10) + CHAR(9) + 'DROP PROCEDURE [DBO].[' + @PROCEDURENAME + '] '+ CHAR(13) +'END'
PRINT 'GO'
PRINT @TEXT
--SELECT @TEXT
PRINT 'GO'

DECLARE PERMISSIONS_CURSOR CURSOR FOR

SELECT PERMISS.STATE_DESC,PERMISS.PERMISSION_NAME,PRINC.NAME
FROM SYS.DATABASE_PRINCIPALS AS PRINC
INNER JOIN SYS.DATABASE_PERMISSIONS AS PERMISS ON PERMISS.GRANTEE_PRINCIPAL_ID = PRINC.PRINCIPAL_ID
WHERE PERMISS.MAJOR_ID=@PROCEDUREID

OPEN PERMISSIONS_CURSOR
FETCH NEXT FROM PERMISSIONS_CURSOR INTO @GRANT_CMD,@GRANT_LEVEL,@GRANT_ROLE
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @GRANT_CMD + ' ' + @GRANT_LEVEL + ' ON [DBO].[' + @PROCEDURENAME + '] TO [' + @GRANT_ROLE + '] AS [DBO]'
PRINT 'GO'
FETCH NEXT FROM PERMISSIONS_CURSOR INTO @GRANT_CMD,@GRANT_LEVEL,@GRANT_ROLE
END
CLOSE Permissions_Cursor
DEALLOCATE Permissions_Cursor

PRINT '---------------------------  END PROC (' + @PROCEDURENAME + ' ) DATE ' + CONVERT(CHAR(10),@FILTER_DATE,126) + '  -------------------------'

FETCH NEXT FROM PROC_CURSOR INTO @PROCEDURENAME,@PROCEDUREID

END
CLOSE PROC_CURSOR
DEALLOCATE PROC_CURSOR

Quickly Idenitfy Most Recently Changed/Modified Stored Procedure In Sql Server

SELECT  NAME ,
        MODIFY_DATE ,
        CREATE_DATE
FROM    SYS.OBJECTS
WHERE   TYPE = 'P'
        AND DATEDIFF(D, MODIFY_DATE, GETDATE()) < 7
ORDER BY MODIFY_DATE DESC;

Simplest Example Of The SQL Server Cursor

DECLARE @FIRST_ID varchar(100);
DECLARE @GET_FIRST_ID CURSOR;

SET @GET_FIRST_ID = CURSOR
FOR
SELECT  COLUMNAME FROM DBO.TABLENAME;

OPEN @GET_FIRST_ID;
FETCH NEXT FROM @GET_FIRST_ID 

INTO @FIRST_ID;

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @FIRST_ID;
FETCH NEXT FROM @GET_FIRST_ID INTO @FIRST_ID;
END;

CLOSE @GET_FIRST_ID;
DEALLOCATE @GET_FIRST_ID;

SQL Function To Split String Using Split (Comma Separated String )

CREATE FUNCTION dbo.Fn_Split
    (
      @INPUT VARCHAR(MAX) ,
      @SEPARATOR NVARCHAR(5)
    )
RETURNS @ReturnTabValue TABLE
    (
      Value NVARCHAR(MAX)
    )
AS
    BEGIN
        WHILE ( CHARINDEX(@SEPARATOR, @INPUT) > 0 )
        BEGIN
INSERT INTO @ReturnTabValue( Value)
            SELECT  Value = LTRIM(RTRIM(SUBSTRING(@INPUT, 1,CHARINDEX(@SEPARATOR,@INPUT) - 1)));

            SET @INPUT = SUBSTRING(@INPUT,CHARINDEX(@SEPARATOR, @INPUT)+ LEN(@SEPARATOR), LEN(@INPUT));
        END

        INSERT  INTO @ReturnTabValue( Value )
             SELECT  Value = LTRIM(RTRIM(@INPUT));
        
DELETE  FROM @ReturnTabValue WHERE   ISNULL(Value, '') = ''
        RETURN
    END
GO

Remove Non Alphabetic Characters From String In Sql Server

CREATE FUNCTION [dbo].[RemoveNonAlphabeticChar] 
( @INPUT VARCHAR(4000) )
RETURNS VARCHAR(4000)
AS
    BEGIN

        DECLARE @AlphabetsChar AS VARCHAR(100)
        SET @AlphabetsChar = '%[^a-z ]%'
        WHILE PATINDEX(@AlphabetsChar, @INPUT) > 0
            
SET @INPUT = STUFF(@INPUT, PATINDEX(@AlphabetsChar, @INPUT), 1, '')

        RETURN @INPUT
END