Creates a unique value of type uniqueidentifier.
We can use this function to randomly sort records in the table
Example
--***** NEWID() *********
SELECT TOP 10 * FROM wages ORDER BY NEWID()
You will get new set records everytime you run the above query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment