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;

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

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

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

评论: 0 | 引用: 0 | 查看次数: 206
发表评论
登录后再发表评论!