diegodfsd
10/2/2012 - 10:33 PM

SQL Server ResultSet Random

SQL Server ResultSet Random

;with todos as
 (
	select top(100) 
		   IdProduto
		  ,Nome
		  ,PalavraChave
		  ,(ABS(CAST(BINARY_CHECKSUM(*) * RAND() as int))% 100) as rnd
	  from Produto
  )

select * from todos;