Random rnd = new Random(unchecked((int)DateTime.Now.Ticks));

        int intRandomNumber = rnd.Next();

        string sql = "select top 10 * from [user] Order By  Rnd(" + (-1 * intRandomNumber) + "*userid)";

        userid是表的自动编号

vb.net

    Dim TimeString As String = DateTime.Now.Ticks.ToString()
    Dim a As UInt32 = UInt32.Parse(TimeString.Substring(TimeString.Length - 8, 8))
    Dim b As Int32 = BitConverter.ToInt32(BitConverter.GetBytes(a), 0)
    Dim rnd As Random = New Random(b)
    Dim intRandomNumber As Integer = rnd.Next