自定义长度随机字符函数

柔光的暖阳◎ 2023-06-21 15:29 37阅读 0赞

use master;
    go
    create view v_random as select newid() as MacoId; 
    
    go
    
    CREATE TABLE privs_test
    (
    Ownername varchar (300) COLLATE Chinese_PRC_CI_AS NULL,
    tablename varchar (300) COLLATE Chinese_PRC_CI_AS NULL,
    usernm varchar (300) COLLATE Chinese_PRC_CI_AS NULL,
    grantor varchar (300) COLLATE Chinese_PRC_CI_AS NULL,
    typename varchar (300) COLLATE Chinese_PRC_CI_AS NULL,
    actionname varchar (300) COLLATE Chinese_PRC_CI_AS NULL,
    clu varchar (300) COLLATE Chinese_PRC_CI_AS NULL
    );
    
    GO
    
    create function [dbo].[m_rand](@mycount int)  
    returns nvarchar(2000)  
    as  
    begin  
           declare @maco_wang table (id varchar(1))  
           declare @maco_number int,@number int;  
           declare @my_one nvarchar(max),@my_two nvarchar(max)  
           set @my_one='';set @maco_number=0; set @number =48;  
           while (@number>=48 and @number<=57) or (@number>=65 and @number<=90) or (@number>=97 and @number<=122)   
           begin  
               insert into @maco_wang select char(@number)  
               set @number=@number+1;  
               if(@number=58)  
               begin  
                  set @number=65            
               end  
               if(@number=91)  
               begin       
                  set @number=97     
               end  
           end  
           while @maco_number<@mycount  
           begin  
                  select @my_two=id from @maco_wang  
                  order by (select MacoId from dbo.v_random);  
                  set @my_one=@my_two+@my_one;  
                  set @maco_number=@maco_number+1;  
           end  
        return @my_one  
    end;