我黑道的

摘要： rand():取随机数,select rand() from T 结果:0.635811742495648round():保留N位小数,四舍五入select round(1.0446,N)floor():舍掉小数select floor(123.756) 结果:123ceiling():向上舍入为指... 阅读全文

摘要： declare @i int set @i=1 while @i<=10000000begin insert into dbo.Persons (Age,Sex,Grade,Name) values(cast( floor(rand()*100) as int),'男','2','张三') set ... 阅读全文