DECLARE @RandomNumber float
DECLARE @RandomInteger int
DECLARE @MaxValue int
DECLARE @MinValue int
 
SET @MaxValue = 4
SET @MinValue = 2
 
SELECT @RandomNumber = RAND()

/*http://www.codesake.com*/
public class MISC
{
      private static Random random = new Random((int)DateTime.Now.Ticks);
      public static int Next(int minValue, int maxValue)
      {
         lock (random)
         {
            return random.Next(minValue, maxValue);
         }

public static string RandomAlphaNumeric(int digits)
{
  Random random = new Random();
  byte[] buffer = new byte[digits / 2];
  random.NextBytes(buffer);
  string result = String.Concat(
  buffer.Select(x => x.ToString("X2")).ToArray());
  if (digits % 2 == 0)
  {
    return result;