- 1. DataScramble - Randomizing data rows
- / Transact-SQL /
- ... 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', ...
- Created on 07 December 2012
- 2. DataJumble - Shuffling characters in a data value
- / Transact-SQL /
- ... the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again ...
- Created on 01 August 2012