Returning a Random set of Records

The NEWID() function returns a uniqueidentifier for each row of data that is returned.

Execute the following query in the AdventureWorks database:

select top 5 productid, name from production.productorder by newid()

Here are the results:

productid   name----------- --------------------------------------------------917         LL Mountain Frame - Silver, 42722         LL Road Frame - Black, 58372         Thin-Jam Hex Nut 8969         Touring-1000 Blue, 60328         Mountain End Caps(5 row(s) affected)

Execute the query again and you get a completely different set of results:

productid   name----------- --------------------------------------------------861         Full-Finger Gloves, S440         Lock Nut 16526         HL Shell451         Lock Nut 11406         External Lock Washer 5(5 row(s) affected)

Share the Post:

Revolutionizing Search: A Glimpse Into Google’s Generative Experience

June 6, 2023

Google is revolutionizing the search experience as we know it with its latest generative experience. No longer will you be bound by the limitations of traditional keyword searching. Now, you

10 Productivity Hacks to Supercharge Your Business in 2023

June 5, 2023

Picture this: your team working seamlessly, completing tasks efficiently, and achieving goals with ease. Sounds like too good to be true? Not at all! With our productivity hacks, you can

GM Creates Open Source uProtocol and Invites Automakers to Adopt It: Revolutionizing Automotive Software Development.

June 2, 2023

General Motors (GM) recently announced its entry into the Eclipse Foundation. The Eclipse Foundation is a prominent open-source software foundation. In addition, GMC announced its contribution of “uProtocol” to facilitate

What is Metadata?

June 1, 2023

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

What We Should Expect from Cell Phone Tech in the Near Future

May 31, 2023

The earliest cell phones included boxy designs full of buttons and antennas, and they only made calls. Needless to say, we’ve come a long way from those classic brick phones

Where to find the Best Mechanical Keyboards for Programmers

The Best Mechanical Keyboards For Programmers: Where To Find Them

May 29, 2023

When it comes to programming, a good mechanical keyboard can make all the difference. Naturally, you would want one of the best mechanical keyboards for programmers. But with so many

The Digital Panopticon: Is Big Brother Always Watching Us Online?

May 26, 2023

In the age of digital transformation, the internet has become a ubiquitous part of our lives. From socializing, shopping, and learning to more sensitive activities such as banking and healthcare,

Embracing Change: How AI Is Revolutionizing the Developer’s Role

May 25, 2023

The world of software development is changing drastically with the introduction of Artificial Intelligence and Machine Learning technologies. In the past, software developers were in charge of the entire development

The Benefits of Using XDR Solutions

May 24, 2023

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

How AI is Revolutionizing Fraud Detection

May 23, 2023

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

Companies Leading AI Innovation in 2023

May 22, 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

Step-by-Step Guide to Properly Copyright Your Website

May 18, 2023

Creating a website is not easy, but protecting your website is equally important. Implementing copyright laws ensures that the substance of your website remains secure and sheltered. Copyrighting your website