摘要:
建立地区表 , 且插入模拟的几条数据 1 CREATE TABLE City 2 ( 3 id INT PRIMARY KEY IDENTITY(100, 10), 4 name VARCHAR(20) NOT NULL, 5 parentid INT NOT NULL 6 ) 7 8 INSERT INTO City VALUES('北京', -1) 9 INSERT INTO City VALUES('东城', 100)10 INSERT INTO City VALUES('西城', 100)11 INSERT INTO City VALUE 阅读全文