代码还在完善中

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[t]

GO

CREATE TABLE [dbo].[t] (

[id] [int] IDENTITY (1, 1) NOT NULL ,

[lid] [nvarchar] (50) ,

[name] [nvarchar] (50) ,

[type] [int] NOT NULL

)

GO

insert into t (lid,[name],[type])

select "11","城站火车站",0

union all select "11","葵巷建国路口",0

union all select "11","菜市桥",0

union all select "11","潮鸣寺巷",0

union all select "11","宝善桥建国路口",0

union all select "11","宝善桥",0

union all select "11","市体育馆",0

union all select "11","武林广场",0

union all select "11","武林门",0

union all select "11","武林们马塍路口",0

union all select "11","八字桥",0

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ... 下一页  >>