Search - Joel Lipman .Com

1. DataScramble - Randomizing data rows: / Transact-SQL /; ... if Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, ...; Created on 07 December 2012
2. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, ...; Created on 01 August 2012