How can we insert random values into a newly created column in a table in SQL Server?
I tried this:
alter table [dbo].[employee] add phoneno int
select * from [dbo].[employee]
update employee set phoneno=(ROUND((RAND(),0)) where phoneno NULL
-
2Why do you want to insert random values instead of a placeholder for unknown, such as NULL or 0? Also, with the code you tried, what was the outcome, did it error?– HandyDMar 28, 2019 at 5:53
-
How do I generate random number for each row in a TSQL Select?– Denis RubashkinMar 28, 2019 at 8:23
Add a comment
|
1 Answer
Rather than two steps you could define the initial values using a DEFAULT constraint on the new column.
