Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 121 of 212

109 C H A P T E R 6 | More analytics Function type Function Description Date and time CALENDAR() Returns a table with one column named Date, containing a date range based on start and end dates that you provide as arguments. CALENDARAUTO() Returns a table with one column named Date, containing a date range based on minimum and maximum dates present in the model's tables. DATEDIFF() Returns the count of intervals (such as DAY or WEEK) between the start and end dates provided as arguments. Filter ADDMISSINGITEMS() Includes rows with missing values in the result set. SUBSTITUTEWITHINDEX() Returns a table containing the results of a left semi-join between two tables, replacing common columns in these tables with a single index column. Information ISONORAFTER() Returns a Boolean value for each row to indicate whether two values (such as a column value and a constant value) are the same. Math and Trig ACOS() Returns the arccosine, or inverse cosine, of a number. ACOSH() Returns the inverse hyperbolic cosine of a number. ASIN() Returns the arcsine, or inverse sine, of a number. ASINH() Returns the inverse hyperbolic sine of a number. ATAN() Returns the arctangent, or inverse tangent, of a number. ATANH() Returns the inverse hyperbolic tangent of a number. COMBIN() Returns the total number of possible groups of a number for a specified number of items. COMBINA() Returns the number of combinations with repetitions of a number for a specified number of items. COS() Returns the cosine of a number. COSH() Returns the hyperbolic cosine of a number. DEGREES() Converts radians into degrees. EVEN() Rounds a number up to the nearest even integer. EXP() Returns a decimal number for e raised to the power of a given number. GCD() Returns the greatest common divisor between two specified numbers as an integer without a remainder. ISO.CEILING() Rounds a number up to the nearest integer or to the nearest multiple of significance. LCM() Returns the least common multiple between two specified integers.

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016