GeoJSON is a format for encoding a variety of geographic data structures. This group is equivalent to the one call made to the TRANSLATE function in the preceding SELECT: SELECT In the following SELECT statement, there is a group of four nested calls to the REPLACE function. The following query replaces square and curly braces in the input string with parentheses: SELECT TRANSLATE('2*/', '()()') Replace square and curly braces with regular braces This is dissimilar to the behavior of multiple REPLACE functions, as each function call would replace all relevant characters, even if they had been replaced by a previous nested REPLACE function call. A single value in the characters parameter, can replace multiple characters in inputString. TRANSLATE does not, however, replace any individual character in inputString more than once. The behavior of the TRANSLATE function is similar to using multiple REPLACE functions. TRANSLATE will return NULL if any of the arguments are NULL. TRANSLATE will return an error if characters and translations expressions have different lengths. Returns a character expression of the same data type as inputString where characters from the second argument are replaced with the matching characters from third argument. translations must be the same data type and length as characters. Is a string expression containing the replacement characters. characters can be any character data type. Is a string expression containing characters that should be replaced. inputString can be any character data type (nvarchar, varchar, nchar, char). To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
0 kommentar(er)
