Yearly Archives: 2012

DBA or Developers both are habitual of using multiple SQL server remotely from one server. But the normal issue of running commands on wrong servers due to less of attention on server name displaying in SSMS query windows pane. We can give different color codes to different server to make them more identifiable in single … Continue reading →

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 →