sql全国省市联动级联代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】 sql全国省市联动级联
作者:Dezai.CN / 发布于2011/8/7/ 791
<div>
<pre>
以下只是部分代码，完整代码在附件
/*添加数据*/
/*添加国家表数据*/
INSERT INTO Nation(Ncode,Nname) VALUES(100000,'中国')

/*添加省份表数据*/
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(110000,'北京市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(120000,'天津市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(130000,'河北省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(140000,'山西省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(150000,'内蒙古自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(210000,'辽宁省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(220000,'吉林省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(230000,'黑龙江',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(310000,'上海市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(320000,'江苏省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(330000,'浙江省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(340000,'安徽省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(350000,'福建省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(360000,'江西省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(370000,'山东省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(410000,'河南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(420000,'湖北省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(430000,'湖南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(440000,'广东省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(450000,'广西壮族自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(460000,'海南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(500000,'重庆市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(510000,'四川省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(520000,'贵州省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(530000,'云南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(540000,'西藏自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(610000,'陕西省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(620000,'甘肃省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(630000,'青海省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(640000,'宁夏回族自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(650000,'新疆维吾尔自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(710000,'台湾省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(810000,'香港特别行政区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(820000,'澳门特别行政区',100000)
</pre>
</div>
试试其它关键字
　省市联动级联　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)