Sfrgttk

Why are there no referendums in the US?

What is paid subscription needed for in Mortal Kombat 11?

What can we do to stop prior company from asking us questions?

How does buying out courses with grant money work?

How to be diplomatic in refusing to write code that breaches the privacy of our users

What happens if you roll doubles 3 times then land on "Go to jail?"

How to write papers efficiently when English isn't my first language?

What is the best translation for "slot" in the context of multiplayer video games?

Method to test if a number is a perfect power?

How do I extract a value from a time formatted value in excel?

Why escape if the_content isnt?

Pre-amplifier input protection

How to Reset Passwords on Multiple Websites Easily?

Was a professor correct to chastise me for writing "Dear Prof. X" rather than "Dear Professor X"?

when is out of tune ok?

How can a function with a hole (removable discontinuity) equal a function with no hole?

How did Arya survive the stabbing?

How can I quit an app using Terminal?

What is the opposite of 'gravitas'?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

How to pronounce the slash sign

Shortcut for value of this indefinite integral?

Flow chart document symbol

What is the intuitive meaning of having a linear relationship between the logs of two variables?

Inserting random values into column

Oracle GoldenGate add trandata errorsTSQL change column constraint between null and not nullHow to update ID=null values in table to incremental counter values?Update all rows from a table with random foreign key from another tabledecrypt data in column before load into destinationInsert output into another newly created tableCannot INSERT Into Newly Created ColumnHow can I get satisfactory random numbers from the RAND function (or elsewhere)?How to INSERT a row INTO a table that has an 'order' column without cursorINSERT Statement error message references column I am not including in query

0

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

sql-server

share|improve this question

edited 4 mins ago

hot2use

8,45552257

asked 42 mins ago

sudhamaisudhamai

1

New contributor

sudhamai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Why 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?
  
  – HandyD
  40 mins ago
  

  
  
  
  

add a comment | 

0

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

sql-server

share|improve this question

edited 4 mins ago

hot2use

8,45552257

asked 42 mins ago

sudhamaisudhamai

1

New contributor

sudhamai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Why 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?
  
  – HandyD
  40 mins ago
  

  
  
  
  

add a comment | 

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

sql-server

share|improve this question

edited 4 mins ago

hot2use

8,45552257

asked 42 mins ago

sudhamaisudhamai

1

New contributor

sudhamai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

alter table [dbo].[employee] add phoneno int



select * from [dbo].[employee]

update employee set phoneno=(ROUND((RAND(),0)) where phoneno NULL

share|improve this question

edited 4 mins ago

hot2use

8,45552257

asked 42 mins ago

sudhamaisudhamai

1

New contributor

sudhamai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 4 mins ago

hot2use

8,45552257

asked 42 mins ago

sudhamaisudhamai

1

New contributor

sudhamai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 4 mins ago

hot2use

8,45552257

edited 4 mins ago

hot2use

8,45552257

asked 42 mins ago

sudhamaisudhamai

1

New contributor

sudhamai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 42 mins ago

sudhamaisudhamai

1