New Transact SQL Video Tutorial: Two Ways to Generate Random Numbers and Random Rows From a SQL Server Table (SQL Server 2000)

Two Ways to Generate Random Numbers and Random Rows From a SQL Server Table (SQL Server 2000) - view details

Everyone wants to know how to randomize rows and numbers in SQL Server and this video shows you how using different techniques.

Note: This video is for SQL Server 2000 but the same concepts apply to SQL Server 2000

Highlights from this video:

• Using the TOP operator to return "x" number of rows
• Retrieving random rows
• Using RAND() to generate random values
• Using NEWID() to generate random uniqueidentifiers (GUIDs)
• Deterministic functions vs. Non-Deterministic functions
• Optimizing your code for faster execution when retrieving random values

• Category: Design Patterns for Transact-SQL
• Skill Level: 300 (Intermediate)
• Length: 16:41 (12.1MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video