MSSQL 随机数+指定字符串截取
declare @User_CodeV nvarchar(500) , @User_Pwd nvarchar(500) , @User_Name nvarchar(500) , @RndId nvarchar(500) ,@identity numeric(18,0) select @RndId =cast(ceiling(rand(checksum(newid()))*10000) as int) select @User_CodeV='BI_jinzhao' , @User_Pwd=left( @User_CodeV, charindex('_',@User_CodeV)-1) +@RndId ,@User_Name='https://www.cnblogs.com/panjinzhao/p/16649402.html'