随机抽取数据库存放的电话号码,类似抽奖的一段sql语句
Random R = new Random();
int intRandomNumber = R.Next(1,1000);
string sql = "select top 10 id As 序号,Title As 标题 from Document Order By Rnd("
+ (-1 * intRandomNumber).ToString() + "*id)";
........
..........
Random R = new Random();
int intRandomNumber = R.Next(1,1000);
string sql = "select top 10 id As 序号,Title As 标题 from Document Order By Rnd("
+ (-1 * intRandomNumber).ToString() + "*id)";
........
..........