木子屋
 

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

作者: dnawo

日期: 2026-05-19 09:03 PM

分类: Web编程

内容: 生成双字母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)

 

登录

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.031 ms

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

你没有权限发表评论

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.031 ms

暂无评论

返回

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.031 ms