The script is self-explanatory. It can be expanded to more random strings by using a different modulo. Using a RAND() is no good if you were to load data with a single SELECT INTO or bcp because the same random seed is used.
CREATE TABLE TESTB ( COL1 INT , COL2 CHAR(08) DEFAULT CASE CAST( ASCII (SUBSTRING( CAST( NEWID() AS VARCHAR(64)), 1, 1)) AS INT) % 2 WHEN 0 THEN 'OPTION 1' ELSE 'OPTION 2' END )
Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.
2009-06-09
5,075 reads
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
283 reads
2008-12-12 (first published: 2008-11-19)
842 reads
This article presents a possible solution to the raffle logistics employed in SQL Server user group meetings around the world.
2011-01-06
3,726 reads
