Posted on Friday, 10th October 2008 by chris
–测试数据
CREATE TABLE tb(ID char(3),PID char(3),Name nvarchar(10))
INSERT tb SELECT ‘001′,NULL ,’山东省’
UNION ALL SELECT ‘002′,’001′,’烟台市’
UNION ALL SELECT ‘004′,’002′,’招远市’
UNION ALL SELECT ‘003′,’001′,’青岛市’
UNION ALL SELECT ‘005′,NULL ,’四会市’
UNION ALL SELECT ‘006′,’005′,’清远市’
UNION ALL SELECT [...]
Tags: SQL
Posted in SQL | Comments (0)
