PurchaseOrderDetail as pod join dbo. Split ';', pod. Comments as cn on cn. Comments as cno on cno. Improve this question. Jiminy Jiminy 10 10 silver badges 17 17 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Matt Hamilton Matt Hamilton k 60 60 gold badges silver badges bronze badges. Thanks Matt, if you find your way in to Melbourne sometime we'll have to sort you out a beer — Jiminy.
KM you're right, and if this option was available to me I'd take it. But sometimes you can't change the schema, even though you'd like to. However I do think I'll create a view that should make the query using this table easier to write. Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic.
Operate on a single value and then return a single value. Scalar functions can be used wherever an expression is valid. SQL Server built-in functions are either deterministic or nondeterministic. Functions are deterministic when they always return the same result any time they are called by using a specific set of input values.
Functions are nondeterministic when they could return different results every time they are called, even with the same specific set of input values. Functions that take a character string input and return a character string output use the collation of the input string for the output. Functions that take non-character inputs and return a character string use the default collation of the current database for the output. Functions that take multiple character string inputs and return a character string use the rules of collation precedence to set the collation of the output string.
Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. What are the SQL database functions? Select Language:. It also has the Help File, and the Header files for native development, and the Northwind sample application. Details Version:. File Name:. Date Published:.
File Size:.
0コメント