Random Number Generation

Objective: Random number generation from 1 to any number using ROWID


//SQL SERVER 2005 - MAKE SURE THE COLUMN NAME MUST BE UNIQUE

SELECT ROW_NUMBER() OVER(ORDER BY DATABASENAME) AS SERIALNUMBER,databasename from DBMONITOR.dbo.T_SHRINKLOGHISTORY

GO

IN SQL SERVER 2000

WE CAN USE THE FOLLOWING METHOD:

DROP TABLE #A
SELECT IDENTITY(INT, 0,1) AS Rank ,databasename INTO
#A from DBMONITOR.dbo.T_SHRINKLOGHISTORY
SELECT * FROM #A

//SQL SERVER 2005

Declare @table table(id int identity(1,1),databasename varchar(20))
insert into @table
select databasename from T_SHRINKLOGHISTORY
select * from @table


Also refer http://www.sqlteam.com/article/returning-a-row-number-in-a-query