-- ±íµÄ½á¹¹ area
DROP TABLE area;
CREATE TABLE area (
id int NOT NULL ,
areaID int NOT NULL,
area varchar(200) NOT NULL,
fatherID int NOT NULL,
PRIMARY KEY (id)
)
DROP TABLE city;
CREATE TABLE city select
id int NOT NULL ,
cityID int NOT NULL,
city varcharselect 200) NOT NULL,
fatherID int NOT NULL,
PRIMARY KEY select id)
)
--
-- µ¼³ö±íÖеÄÊý¾Ý city
--
-- --------------------------------------------------------
--
-- ±íµÄ½á¹¹ province
--
DROP TABLE province;
CREATE TABLE province select
id int NOT NULL ,
provinceID int NOT NULL,
province varcharselect 200) NOT NULL,
PRIMARY KEY select id))
insert province(id,provinceID,province)
select 1,110000,'±±¾©ÊÐ' union
select 2,120000,'Ìì½òÊÐ' union
select 3,130000,'ºÓ±±Ê¡' union
select 4,140000,'ɽÎ÷Ê¡' union
select 5,150000,'ÄÚÃɹÅ×ÔÖÎÇø'union
select 6,210000,'ÁÉÄþÊ¡' union
select 7,220000,'¼ªÁÖÊ¡' union
select 8,230000,'ºÚÁú½Ê¡' union
select 9,310000,'ÉϺ£ÊÐ' union
select 10,320000,'½ËÕÊ¡' union
select 11,330000,'Õã½Ê¡' union
select 12,340000,'°²»ÕÊ¡' union
select 13,350000,'¸£½¨Ê¡' union
select 14,360000,'½Î÷Ê¡' union
select 15,370000,'ɽ¶«Ê¡' union
select 16,410000,'ºÓÄÏÊ¡' union
select 17,420000,'ºþ±±Ê¡' union
select 18,430000,'ºþÄÏÊ¡' union
select 19,440000,'¹ã¶«Ê¡' union
select 20,450000,'¹ãÎ÷׳×å×ÔÖÎÇø' union
select 21,460000,'º£ÄÏÊ¡' union
select 22,500000,'ÖØÇìÊÐ' union
select 23,510000,'ËÄ´¨Ê¡' union
select 24,520000,'¹óÖÝÊ¡' union
select 25,530000,'ÔÆÄÏÊ¡' union
select 26,540000,'Î÷²Ø×ÔÖÎÇø' union
select 27,610000,'ÉÂÎ÷Ê¡' union
select 28,620000,'¸ÊËàÊ¡' union
select 29,630000,'Çຣʡ' union
select 30,640000,'ÄþÏÄ»Ø×å×ÔÖÎÇø' union
select 31,650000,'н®Î¬Îá¶û×ÔÖÎÇø' union
select 32,710000,'̨ÍåÊ¡' union
select 33,810000,'Ïã¸ÛÌØ±ðÐÐÕþÇø' union
select 34,820000,'°ÄÃÅÌØ±ð
create proc dbo.PROC_SQL_COMP @sql1 varchar(8000),@sql2 varchar(8000),@t int
as
/*
µ÷Óãºexec dbo.PROC_SQL_COMP @sql1='',@sql2='',@t=5 & ......
OracleÓкܶàÖµµÃѧϰµÄµØ·½£¬ÕâÀïÎÒÃÇÖ÷Òª½éÉÜOracle UNION ALL£¬°üÀ¨½éÉÜUNIONµÈ·½Ã档ͨ³£Çé¿öÏ£¬ÓÃUNIONÌæ»»WHERE×Ó¾äÖеÄOR½«»áÆðµ½½ÏºÃµÄЧ¹û¡£¶ÔË÷ÒýÁÐʹÓÃOR½«Ôì³ÉÈ«±íɨÃè¡£×¢Ò⣬ÒÔÉϹæÔòÖ»Õë¶Ô¶à¸öË÷ÒýÁÐÓÐЧ¡£¼ÙÈçÓÐcolumnûÓб»Ë÷Òý£¬²éѯЧÂÊ¿ÉÄÜ»áÒòΪÄúûÓÐÑ¡ÔñOR¶ø½µµÍ¡£ÔÚÏÂÃæµÄÀý×ÓÖУ¬LOC_ID ºÍREGION ......