SQL Server Update with random value number between 10-100

 



How to SQL Server Update with random value number between 10-100

Try this

UPDATE tableName SET columnName = FLOOR( 10 + RAND( ) * 100 );

I hope it can help. 


Post a Comment

Thank for leaving message

أحدث أقدم
managed wordpress hosting
managed wordpress hosting