SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Hannan Kravitz

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Round Natural Numbers to the nearest Power of 10

An ITVF function that rounds a number to the nearest Power of 10   Read more...
By Hannan Kravitz 2017/05/15 | Source: SQLServerCentral.com | Category: round
Rating: (not yet rated) |  Discuss |   Briefcase | 196 reads

Function - Word count in a sentence

The function (Inline function) is used to determine the word count in a textual/string input. * Compatible from SQL Server 2012 and up.  Read more...
By Hannan Kravitz 2016/11/11 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 367 reads

Equivalent Oracle's INSTR Function in SQL server

Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.  Read more...
By Hannan Kravitz 2016/11/17 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 503 reads
   Items 1 to 3 of 3