number to words Convert SQL Query

Number to words Convert SQL Query

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