Date/Time Functions – SYSDATETIME()

I am going to start a series of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Not only is it important to know when a sales order came in, but we should fulfill the request using some type of queue (LIFO). If if was a stack (FIFO) implementation, the first person may never get his order! I will be exploring functions that return the current system date and time in a defined data type…

Math Functions – RAND()

I am going to wrap up my short articles on non-trigonometric Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. Today, I will be exploring the RAND() function. This function takes an optional seed number in integer format. It returns a pseudo-random float value from 0…

Math Functions – LOG10() vs POWER()

I am going to gain ground on completing my short articles on non-trigonometric Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. Today, I will be exploring the LOG10() and POWER() functions. The common logarithm of number x is the power y to which 10 would…

Math Functions – EXP() vs LOG()

I am going to forge ahead and write another short article or tidbit on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the natural logarithm LOG() and exponential EXP() and functions. The natural logarithm is based on the transcendental constant e…

Math Functions – SQRT()

I am going to knuckle down and write another short article or tidbit on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the SQRT() function today. This function takes an expression of type float or of a type that can be…

Math Functions – SQUARE()

I am going to dig in and write another short article or tidbit on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the SQUARE() function today. This function takes a number N as input in either exact numeric or approximate numeric…

Math Functions – POWER()

I am going to remain on course with my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the POWER() function today. This function takes two expressions, a base B and a exponent/power N, as…

Math Functions – SIGN()

I am going to press on with my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the SIGN() function today. This function takes as input a expression in either exact numeric or approximate numeric…

Math Functions – PI()

I am going to stick at writing my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the PI() function today. This simple function returns the mathematical constant of PI as a float. This function…

Math Functions – ROUND()

I am going to keep going with my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the ROUND() function today. This function takes as input a expression in either exact numeric or approximate numeric…