2021最完整省份、城市、银行、分行、超网号、卡Bin信息，表结构及数据创建脚本

 create table BankBranch ( UnitedBankNo VARCHAR(32) not null, Status bit, BankCode VARCHAR(16) not null, ClearingBankNumber VARCHAR(64), ProvinceCode VARCHAR(16), OriCityCode VARCHAR(16), FullName NVARCHAR(256) not null, ) GO exec sp_addextendedproperty 'MS_Description','银行支行信息表','Schema','dbo','table','BankBranch',null,null exec sp_addextendedproperty 'MS_Description','联行号','Schema','dbo','table','BankBranch','column','UnitedBankNo' exec sp_addextendedproperty 'MS_Description','状态1：有效0：无效','Schema','dbo','table','BankBranch','column','Status' exec sp_addextendedproperty 'MS_Description','所属银行代码','Schema','dbo','table','BankBranch','column','BankCode' exec sp_addextendedproperty 'MS_Description','清算行号','Schema','dbo','table','BankBranch','column','ClearingBankNumber' exec sp_addextendedproperty 'MS_Description','省份代码','Schema','dbo','table','BankBranch','column','ProvinceCode' exec sp_addextendedproperty 'MS_Description','城市代码','Schema','dbo','table','BankBranch','column','OriCityCode' exec sp_addextendedproperty 'MS_Description','支行全称','Schema','dbo','table','BankBranch','column','FullName' GO insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308290003757', 1, '308', '2900', '招商银行股份有限公司上海金钟路支行', '308584000013', '2900'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308290003773', 1, '308', '2900', '招商银行股份有限公司上海陆家嘴支行', '308584000013', '2900'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308394200041', 1, '308', '3942', '招商银行股份有限公司莆田仙游支行', '308584000013', '3910'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308581002503', 1, '308', '5810', '招商银行股份有限公司广州光大花园支行', '308584000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308581002511', 1, '308', '5810', '招商银行股份有限公司广州星河湾支行', '308584000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308581002538', 1, '308', '5810', '招商银行股份有限公司广州狮岭支行', '308584000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308588037208', 1, '308', '5880', '招商银行股份有限公司佛山勒流支行', '308584000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308589500036', 1, '308', '5895', '招商银行股份有限公司江门鹤山支行', '308584000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308591000020', 1, '308', '5910', '招商银行股份有限公司湛江霞山支行', '308584000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308602034276', 1, '308', '6020', '招商银行股份有限公司东莞恒大雅苑支行', '308584000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308641000050', 1, '308', '6410', '招商银行股份有限公司海口国兴支行', '308584000013', '6410'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308701000085', 1, '308', '7010', '招商银行股份有限公司贵阳世纪新城支行', '308584000013', '7010'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308791011397', 1, '308', '7910', '招商银行股份有限公司西安大兴东路支行', '308584000013', '7910'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('308791011401', 1, '308', '7910', '招商银行股份有限公司西安紫薇田园都市支行', '308584000013', '7910'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310134019834', 1, '310', '1340', '上海浦东发展银行股份有限公司保定鑫丰小微支行', '310290000013', '1210'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310290096068', 1, '310', '2900', '上海浦东发展银行股份有限公司浦东机场综合保税区支行', '310290000013', '2900'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310290096076', 1, '310', '2900', '上海浦东发展银行股份有限公司顾村支行', '310290000013', '2900'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310303500047', 1, '310', '3035', '上海浦东发展银行股份有限公司邳州支行', '310290000013', '3010'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310304200056', 1, '310', '3042', '上海浦东发展银行股份有限公司金坛支行', '310290000013', '3010'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310313200015', 1, '310', '3132', '上海浦东发展银行股份有限公司泰州姜堰支行', '310290000013', '3010'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310331000332', 1, '310', '3310', '上海浦东发展银行杭州建德支行', '310290000013', '3310'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310338400347', 1, '310', '3384', '上海浦东发展银行股份有限公司金华浦江支行', '310290000013', '3310'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310393000049', 1, '310', '3930', '上海浦东发展银行股份有限公司厦门观音山支行', '310290000013', '3910'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310393000057', 1, '310', '3930', '上海浦东发展银行股份有限公司厦门海沧支行', '310290000013', '3910'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310393000065', 1, '310', '3930', '上海浦东发展银行股份有限公司厦门翔安支行', '310290000013', '3910'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310399600013', 1, '310', '3996', '上海浦东发展银行股份有限公司漳州东山支行', '310290000013', '3910'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310585000032', 1, '310', '5850', '上海浦东发展银行股份有限公司广东自贸试验区横琴分行', '310290000013', '5810'); insert into BankBranch (UnitedBankNo, Status, BankCode, OriCityCode, FullName, ClearingBankNumber, ProvinceCode) values ('310641000028', 1, '310', '6410', '上海浦