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, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos
Note: You must have the TSCC codec installed to view this video

0 Comments:
Post a Comment
<< Home