SQL语句应用技术.docVIP

一、建表部分 if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[水运建设投资]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[水运建设投资] GO CREATE TABLE [dbo].[水运建设投资] ( [内河建设投资（亿元）] [numeric](18, 2) NULL , [沿海建设投资（亿元）] [numeric](18, 4) NULL , [年份] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[公路基础建设]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[公路基础建设] GO CREATE TABLE [dbo].[公路基础建设] ( [全国公路总里程（万公里）] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [全国公路密度（公里/百平方公里）] [