生成gb2312汉字表.sql

sqlserver 数据库编程的绝好脚本

SELECT TOP 71 ID=IDENTITY(int,176,1) INTO #a FROM syscolumns
SELECT TOP 94 ID=IDENTITY(int,161,1) INTO #b FROM syscolumns
SELECT ch=CAST(CAST(a.ID as binary(1))+CAST(b.ID as binary(1)) as char(2)) COLLATE Chinese_PRC_CS_AS_KS_WS
FROM #a a,#b b
WHERE NOT(a.ID=215 AND b.ID BETWEEN 250 AND 254)
ORDER BY ch
DROP TABLE #a,#b