Paul Nielsen
pauln at sqlserverbible.com
Mon Mar 24 09:51:46 CDT 2008
John, It is important that random number for the row is permanent? Or is the intention that you're able to randomly select row? -Paul -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, March 24, 2008 10:37 AM To: 'Discussion concerning MS SQL Server' Subject: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com __________ NOD32 2968 (20080324) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com