selecting random values from table in SQL Server 2000
Posted on 2007-12-03
I want to select random values from the table in sql server database.
i.e on button click we should display a value from table xyz and if we click the button again,the value should be changed and it should be some other value from the same table xyz.
and if user is satisfied with the displayed value,on button click(add button) we should insert that value in table abc and delete that particular value from table xyz.