How to create random values for these variables

CREATE TABLE dbo.RandomData (
RowId INT IDENTITY(1,1) NOT NULL,
firstname VARCHAR(10), lastname varchar(10),city varchar(10),state varchar(10),country varchar(30),
age NUMERIC(5),salary numeric(10,2),vacationhrs numeric(5),phoneno numeric(7) )
GO

how to get random values around 10000 records for these columns ?
i mean i want to add 10000 dummy data

Google "sql dummy data generator"

1 Like