资源描述：
《全国省市区数据库sql2000sql语句》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、--省--IFNOTEXISTS(SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[S_Province]')ANDtypein(N'U'))BEGINCREATETABLE[dbo].[S_Province]([ProvinceID][bigint]IDENTITY(1,1)NOTNULL,[ProvinceName][nvarchar](50)COLLATESQL_Latin1_General_CP1_CI_ASNULL,[DateCreated][datetim
2、e]NULL,[DateUpdated][datetime]NULL,CONSTRAINT[PK_S_Province]PRIMARYKEYCLUSTERED([ProvinceID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON))ENDGOSETIDENTITY_INSERT[dbo].[S_Province]ONINSERT[dbo].[S_Province
3、]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUES(1,N'北京市',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A28014555BEASDateTime))INSERT[dbo].[S_Province]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUES(2,N'天津市',CAST(0x00009A28014555BEASD
4、ateTime),CAST(0x00009A28014555BEASDateTime))INSERT[dbo].[S_Province]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUES(3,N'河北省',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A28014555BEASDateTime))INSERT[dbo].[S_Province]([ProvinceID],[ProvinceName],[Da
5、teCreated],[DateUpdated])VALUES(4,N'山西省',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A28014555BEASDateTime))INSERT[dbo].[S_Province]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUES(5,N'内蒙古自治区',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A28014555
6、BEASDateTime))INSERT[dbo].[S_Province]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUES(6,N'辽宁省',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A28014555BEASDateTime))INSERT[dbo].[S_Province]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUE
7、S(7,N'吉林省',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A28014555BEASDateTime))INSERT[dbo].[S_Province]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUES(8,N'黑龙江省',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A28014555BEASDateTime))INSERT[dbo].[S_Pro
8、vince]([ProvinceID],[ProvinceName],[DateCreated],[DateUpdated])VALUES(9,N'上海市',CAST(0x00009A28014555BEASDateTime),CAST(0x00009A2801
