For some reason I'm getting NULL values with the CHOOSE function, but here is one way CREATE TABLE Foo (Col1 VARCHAR(20), Col2 VARCHAR(20), Col3 VARCHAR(20))
GO
INSERT Foo
VALUES(
CHOOSE((ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) % 3) + 1, 'string1', 'string2', 'string3'),
CHOOSE((ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) % 3) + 1, 'string1', 'string2', 'string3'),
CHOOSE((ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) % 3) + 1, 'string1', 'string2', 'string3')
)
GO 10
SELECT *
FROM Foo
DROP TABLE Foo
Also, you could select from a table:CREATE TABLE Val (Col VARCHAR(20));
INSERT Val VALUES ('string1'), ('string2'), ('string3');
CREATE TABLE Foo (Col1 VARCHAR(20), Col2 VARCHAR(20), Col3 VARCHAR(20));
GO
INSERT Foo
VALUES(
(SELECT TOP 1 Col FROM Val ORDER BY NEWID()),
(SELECT TOP 1 Col FROM Val ORDER BY NEWID()),
(SELECT TOP 1 Col FROM Val ORDER BY NEWID())
)
GO 10
SELECT *
FROM Foo
DROP TABLE Foo
DROP TABLE Val
Populate column with 3 random strings from a list
Posted - 07/12/2012 : 12:01:11
