Category Archives: SQL Server

Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below. String functions · CONCAT : CONCAT takes a variable number of string arguments and concatenates them into a single string. It requires a minimum of two input values; otherwise, an error is raised. All arguments are implicitly converted to string types … Continue reading →

Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below. Logical functions · CHOOSE : CHOOSE acts like an index into an array, where the array is composed of the arguments that follow the index argument. The index argument determines which of the following values will be returned. CHOOSE ( index, … Continue reading →

Microsoft SQL Server 2012 introduces 14 new built-in functions. 7 Out 14 explained below. Date and time functions · DATEFROMPARTS : DATEFROMPARTS returns a date value with the date portion set to the specified year, month and day, and the time portion set to the default. If the arguments are not valid, then an error … Continue reading →

Microsoft SQL Server 2012 introduces 14 new built-in functions. 3 Out 14 explained below. Conversion functions · PARSE (Transact-SQL) : PARSE ( string_value AS data_type [ USING culture ] ) string_value : nvarchar(4000) value representing the formatted value to parse into the specified data type. string_value must be a valid representation of the requested data … Continue reading →

Microsoft SQL Server 2012 introduces 14 new built-in functions. These functions are divided into 4 categories. In this article I will be covering usage & functionality of these new 14 functions. I strongly feel, these functions are very useful for developer point of view. These new functions are: 1) Conversion functions · PARSE (Transact-SQL) · … Continue reading →