|
|
Posted by THO on 09/03/07 15:05
In article <#3CNDfj7HHA.5012@TK2MSFTNGP02.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
wrote:
> You can have the following expression as a default value for the column:
>
> (RAND()*900) + 100
If that is the default value, it will grab a random number within that
range and assign a different number to each row, correct? Thanks.
> Note, however, that if you have an INSERT with a subquery, the value will be
> the same for all those
> rows.
Navigation:
[Reply to this message]
|