INSERTION DE N NOMBRES ENTIERS ALÉATOIRES DANS UNE TABLE

CREATE TABLE [dbo].[tab_alea] (
	[nb_al] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO
declare @vi int
set @vi=0
while @vi < '40000'
begin
INSERT INTO tab_alea  
(nb_al)
select substring(convert(varchar(9),RAND()),4,3)+substring(convert(varchar(9),RAND()),5,3)
where substring(convert(varchar(9),RAND()),4,3)+substring(convert(varchar(9),RAND()),5,3) between '100000' and '900000'
             

set @vi=@vi+1
end