c# ip地址生成器到SQL
本文关键字:SQL ip 地址 | 更新日期: 2023-09-27 18:06:12
我有以下python代码,我在互联网上发现,我想在SQL数据库中与每个ipv4地址,有一个表。我不写python代码,但这是我发现的。
我的问题是1:是否有T-SQL代码可以用来生成表?(一列即0.0.0.0-255.255.255.255)2:我怎么在c#中做这个?使用最快的方法?我知道显示结果会使控制台应用程序减慢400%
#!/usr/bin/env python
def generate_every_ip_address():
for octet_1 in range( 256 ):
for octet_2 in range( 256 ):
for octet_3 in range( 256 ):
for octet_4 in range( 256 ):
yield "%d.%d.%d.%d" % (octet_1, octet_2, octet_3, octet_4)
for ip_address in generate_every_ip_address():
print ip_address
这样行吗?
DECLARE @a INTEGER
DECLARE @b INTEGER
DECLARE @c INTEGER
DECLARE @d INTEGER
DECLARE @IPADDRESS nvarchar(50)
set @a = 0
WHILE @a < 256
BEGIN
SET @b = 0
WHILE @b < 256
BEGIN
SET @c = 0
WHILE @c < 256
BEGIN
SET @d = 0
WHILE @d < 256
BEGIN
SET @IPADDRESS = CAST(@a AS nvarchar(3)) + '.' + CAST(@b AS nvarchar(3)) + '.' + CAST(@c AS nvarchar(3)) + '.' + CAST(@d AS nvarchar(3))
PRINT @IPADDRESS
SET @d = @d + 1
END
SET @c = @c + 1
END
SET @b = @b + 1
END
SET @a = @a + 1
END
使用下面的TSQL可以非常直接地批量插入16,581,375行。
DECLARE @Counter INT
SET @Counter = 0
SET NOCOUNT ON ;
WHILE ( @Counter <= 255 )
BEGIN
RAISERROR('Procesing %d' ,0,1,@Counter) WITH NOWAIT ;
WITH Numbers ( N )
AS ( SELECT CAST(number AS VARCHAR(3))
FROM master.dbo.spt_values
WHERE type = 'P'
AND number BETWEEN 0 AND 255
)
INSERT INTO YourTable
( IPAddress
)
SELECT @Counter + '.' + N1.N + '.' + N2.N + '.' + N3.N
FROM Numbers N1 ,
Numbers N2 ,
Numbers N3
SET @Counter = @Counter + 1
END
请使用int IDENTITY列来存储每个IP地址。它们只有32位。