Collections:
Function Argument Modifier
What Is Function Argument Modifier?
✍: FYIcenter.com
Function argument modifier is an expression placed before or after a function argument to modify the behavior of the function. For example:
SET @str = 'Yahooo'; SELECT TRIM(TRAILING 'o' FROM @str); -- +------------------------------+ -- | TRIM(TRAILING 'o' FROM @str) | -- +------------------------------+ -- | Yah | -- +------------------------------+
Sometimes argument modifiers are used to make the function call more readable. For example:
SET @str = 'Yahooo'; SELECT POSITION('o' IN @str), LOCATE('o', @str); -- +-----------------------+-------------------+ -- | POSITION('o' IN @str) | LOCATE('o', @str) | -- +-----------------------+-------------------+ -- | 4 | 4 | -- +-----------------------+-------------------+
⇒ Variable Number of Arguments
⇐ Function Name Case Insensitive
2023-11-14, 263🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...