description User-defined functions accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. A user-defined function is a [!INCLUDE tsql] ...

below is a use demo: Connect to SQL Server, create a table dbo.OrderDetail, and run some sql on this table.

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Erik Steiger discusses the operational pain ...

operand is one of the following: constant is a number or a quoted character string (or other special notation) that indicates a fixed value. Constants are also called literals. Constants are described ...