SQL Query

Some Usefull SQL Query

    1.Encrypt Stored Procedure in SQL

           

Create procedure ProcedureName with encryption  as  Begin  select top 5 * from customers End 2.Convert Text To TitleCase

        CREATE FUNCTION fn_TitleCase (@InputStr VARCHAR(250))    

RETURNS Varchar(250)    

AS BEGIN    

DECLARE @TempStr VARCHAR(250)    

DECLARE @i INT    

SET @TempStr = LOWER(@InputStr)    

SET @TempStr = UPPER(LEFT(@TempStr,1)) + SUBSTRING(@TempStr,2,LEN(@TempStr))    

    

WHILE CHARINDEX(' ',@TempStr,1) > 0    

 BEGIN    

  SET @i = CHARINDEX(' ',@TempStr,1)    

  SET @TempStr = LEFT(@TempStr,@i-1) + '~*' + 

UPPER(SUBSTRING(@TempStr,@i + 1,1)) +SUBSTRING(@TempStr,@i+2,LEN(@TempStr))    

 END    

     

    

 SET @TempStr = REPLACE(@TempStr,'~*',' ')    

 SET @InputStr = @TempStr    

 RETURN @InputStr    

END    

And More..........