摘要： print ‘============================================================================================自己摸索的分页方法======================================================================================... 阅读全文

摘要： SQL codeselect char(cast(rand()*25 as int)+97)+char(cast(rand()*25 as int)+97) select 两位随机字母 = (select top 1 id from (select 'A' as id union select 'B' union select 'C' union select 'D' union select ... 阅读全文

摘要： ==产生数字区间随机数==--创建视图 create view myview as select re=rand() --自定义函数:取得指定范围的随机数 create function mydata( @a int, @b int) returns decimal(38,0) as begin declare @r decimal(38,0) select @r=cast(re*(@b-@a)+... 阅读全文