个人博客开始运营:点击进入我的博客
欢迎大家访问,以及收藏,内容会及时更新的!
Sql server 生成随机数Funciton
1.创建一个视图
Create View RandView
As
Select RAND() As rand
2.生成随机数方法
/*
select char(65+ceiling(rand()*25)) --随机字母(大写)
select char(97+ceiling(rand()*25)) --随机字母(小写)
select cast(ceiling(rand()*9) as varchar(1)) --随机数字 1至9的随机数字(整数)
*/
CREATE FUNCTION [dbo].[RandomNum]
(
-- Add the parameters for the function here
@Count int ---生成长度
)
RETURNS varchar(50)
AS
BEGIN
declare @i int
declare @flag int
declare @value varchar(50)
declare @randomnum float
set @i=1
set @value=''
while @i<=@Count
begin
select @randomnum=rand from RandView
set @flag = ceiling(@randomnum*3)
if @flag = 1
begin
select @randomnum=rand from RandView
set @value=@value+char(65+ceiling(@randomnum*25))
end
if @flag = 2
begin
select @randomnum=rand from RandView
set @value=@value+char(97+ceiling(@randomnum*25))
end
if @flag = 3
begin
select @randomnum=rand from RandView
set @value=@value+cast(ceiling(@randomnum*9) as varchar(1))
end
set @i = @i + 1
end
return @value
END
3.调用方法
select [dbo].[RandomNum](10)
效果图: