[dba-SQLServer] SQL to create Integer Random

I need to create a field that is an integer, and which is then filled with a
random number when the rows are populated.  In Access you could set up an
autonumber with random.  Is it possible to do something like this in SQL
Server?  If now can I do a function in an aliased field, where that random
number is then inserted into the integer field?

John W. Colby
Colby Consulting
www.ColbyConsulting.com