Database

DataView t=new DataView(someTable);<br />
t.RowStateFilter=DataViewRowState.CurrentRows;<br />
		<br />
debug.WriteLine("Rows Count before deletion= "+ t.Count);<br />
t[0].Delete();<br />
debug.WriteLine("Rows Count after deletion = "+ t.Count);

DECLARE @counter smallint
SET @counter = 1
WHILE @counter < 5
   BEGIN
      SELECT RAND(@counter) Random_Number
      SET NOCOUNT ON
      SET @counter = @counter + 1
      SET NOCOUNT OFF
   END
GO

function array_randomise() {
  var li_rnd ;
  var lo_temp ;
  //Move each record to a random position in array ...
  for (var li_loop = 0 ; li_loop < this.length ; li_loop++) {
    li_rnd = Math.round(Math.random() * li_array_len) ;
    lo_temp = this[li_rnd] ;
    this[li_rnd] = this[li_loop] ;
    this[li_loop] = lo_temp ;
  }
}

select ID, NewID() as [guid]
from FOO
order by [guid]