- 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
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