I never remember if a system T-SQL function, with no parameters, requires parenthesis, so I wonder if there is a reason.
For example: CURRENT_TIMESTAMP is a function that doesn't require parenthesis, while SCOPE_IDENTITY() requires them.
I never remember if a system T-SQL function, with no parameters, requires parenthesis, so I wonder if there is a reason.
For example: CURRENT_TIMESTAMP is a function that doesn't require parenthesis, while SCOPE_IDENTITY() requires them.
I think the differences are due to whether the function is a part of the ansi sql standard (which current_timestamp is) or whether it is a sql server function.