全国所有城市SQL
--省级 Provincial
--城市 City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'北京市')
insert into Provincial values(2,'天津市')
insert into Provincial values(3,'上海市')
insert into Provincial values(4,'重庆市')
insert into Provincial values(5,'河北省')
insert into Provincial values(6,'山西省')
insert into Provincial values(7,'台湾省')
insert into Provincial values(8,'辽宁省')
insert into Provincial values(9,'吉林省')
insert into Provincial values(10,'黑龙江省')
insert into Provincial values(11,'江苏省')
insert into Provincial values(12,'浙江省')
insert into Provincial values(13,'安徽省')
insert into Provincial values(14,'福建省')
insert into Provincial values(15,'江西省')
insert into Provincial values(16,'山东省')
insert into Provincial values(17,'河南省')
insert into Provincial values(18,'湖北省')
insert into Provincial values(19,'湖南省')
insert into Provincial values(20,'广东省')
insert into Provincial values(21,'甘肃省')
insert into Provincial values(22,'四川省')
insert into Provincial values(23,'贵州省')
insert into Provincial values(24,'海南省')
insert into Provincial values(25,'云南省')
insert into Provincial values(26,'青海省')
insert into Provincial values(27,'陕西省')
insert into Provincial values(28,'广西壮族自治区')
insert into Provincial values(29,'西藏自治区')
insert into Provincial values(30,'宁夏回族自治区')
insert into Provincial values(31,'新疆维吾尔自治区')
insert into Provincial values(32,'内蒙古自治区')
insert into Provincial values(33,'澳门特别行政区')
insert into Provincial values(34,'香港特别行政区')
--select pid,Provincial from Provincial
create table City(cid int not null,city varchar(50) primary key,pid int foreign key references Provincial(pid))
----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------
相关文档：
CREATE FUNCTION dbo.UF_GetInvoiceSerials( @bizCode VARCHAR(10))
RETURNS VARCHAR(100)
AS
BEGIN
DECLARE @ret AS VARCHAR(1000)
SELECT @ret=Coalesce(@ret + ', ','') +
CASE e.ID
......
方案1 适用于oracle9i以上！
select * from
(select row_number() over(order by sendid desc) rn,m.* from xxt_msgreceive m )
where rn <1010 and rn>=1000
方案2
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from xxt_msg where sendstatus=1 order by msgid desc) A WHERE ROWNUM < ......
今天写网站的时候很囧啊，发现查找用户权限的时候无缘无故的同一个权限重复出现很多次
修改后的SQL语句如下
SELECT
node
.
id
,
node
.
name
,
access
.
role_id
from
think_role_user
AS
user
,
think_access
AS
access
,
think_node
AS
node
WHERE
user
.
user_id
=
......
一、深入浅出理解索引结构
实际上，您可以把索引理解为一种特殊的目录。微软的sql server提供了两种索引：聚集索引（clustered index，也称聚类索引、簇集索引）和非聚集索引（nonclustered index，也称非聚类索引、非簇集索引）。下面，我们举例来说明一下聚集索引和非聚集索引的区别：
其实，我们的汉语� ......
