LOG() funciton in SQL Server 2012

LOG() function has been enhanced in SQL Server 2012 for accepting base value as second argument...

LOG() function used to accept logarithmic value of any base. It accepts base value as second parameter. In SQL Server 2008, LOG() function doesn't accept second argument.

Syntax of LOG() in MSSQL 2012

LOG ( float_expression[, base] )

SELECT LOG(10) as Log10
	,LOG(9,3) as Log10Base3
	,LOG(10,2)AS Log10Base2
	,LOG(10)/LOG(2) as Log10DivideByLog2

Output :

Log10	              Log10Base3	Log10Base2	        Log10DivideByLog2
2.30258509299405	2	      3.32192809488736	     3.32192809488736