T-SQL:com双字母域名生成示例

生成com双字母域名的T-SQL:

WITH Letters AS (
    Select 'a' AS c UNION ALL
    Select 'b' UNION ALL
    Select 'c' UNION ALL
    Select 'd' UNION ALL
    Select 'e' UNION ALL
    Select 'f' UNION ALL
    Select 'g' UNION ALL
    Select 'h' UNION ALL
    Select 'i' UNION ALL
    Select 'j' UNION ALL
    Select 'k' UNION ALL
    Select 'l' UNION ALL
    Select 'm' UNION ALL
    Select 'n' UNION ALL
    Select 'o' UNION ALL
    Select 'p' UNION ALL
    Select 'q' UNION ALL
    Select 'r' UNION ALL
    Select 's' UNION ALL
    Select 't' UNION ALL
    Select 'u' UNION ALL
    Select 'v' UNION ALL
    Select 'w' UNION ALL
    Select 'x' UNION ALL
    Select 'y' UNION ALL
    Select 'z'
)
Insert INTO DomainNameTB (DomainName)
Select L1.c + L2.c + '.com'
FROM Letters L1
CROSS JOIN Letters L2;
GO

如果要生成com三字母域名,只需加一个L3即可,依此类推:

Insert INTO DomainNameTB (DomainName)
Select
    L1.c + L2.c + L3.c + '.com'
FROM Letters L1
CROSS JOIN Letters L2
CROSS JOIN Letters L3;

Tips:com纯字母域名,从L域名到LLLLL域名,各有26、676、17576、456976、11881376个。

上一篇: 黄金价格急涨急跌判断函数(C#版)
下一篇: 这是最新一篇日志
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags:
最新日志:
评论: 0 | 引用: 0 | 查看次数: 19
发表评论
登录后再发表评论!