clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1135837 fiddles created (16673 in the last week).

CREATE TABLE Test01 (RID int IDENTITY(1,1), IP varchar(15))
 hidden batch(es)


DECLARE @TotalNum INT, @Num INT SET @TotalNum = 10 SET @Num =1 WHILE @Num <= @TotalNum BEGIN insert into Test01(IP) SELECT (CONVERT(VARCHAR(4),ROUND(RAND()*254,0))+'.'+ CONVERT(VARCHAR(4),ROUND(RAND()*254,0))+'.'+ CONVERT(VARCHAR(4),ROUND(RAND()*254,0))+'.'+ CONVERT(VARCHAR(4),ROUND(RAND()*254,0))) SET @Num = @Num + 1 END select * from Test01
RID IP
1 91.177.179.78
2 94.175.63.252
3 99.49.123.94
4 35.182.40.3
5 122.37.167.249
6 171.36.213.61
7 28.220.183.224
8 254.224.27.167
9 169.252.172.247
10 231.95.47.97
 hidden batch(es)