STUFF (SQL Server Compact Edition)
Deletes a specified length of characters and inserts another set of characters at a specified starting point.
STUFF ( character_expression, start, length, character_expression )
ROW_NUMBER :
Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
ROW_NUMBER () OVER ( [ ] )
No comments:
Post a Comment