select pcode from (
select h.k,h.d,h.m,h.u,l.areacode,
l.areacode||substr(h.u,4,length(h.u))||h.k pcode
from(
select j.k,j.d,j.m,j.u from(
select lpad(f,3,0) as k,d, m,u from(
select xx.areacode d,nvl(count(cy.pcode),'001')f,mx.m,mx.shopcode u
from cz_s_jtxx xx, cz_s_jtcy cy ,
( select a.m,d.shopid,d.shopcode from
(select shopid m,parentid from s_shop where shoptype=1) a,
(select shopid,parentid from s_shop where shoptype=2) b,
(select shopid,parentid from s_shop where shoptype=3)c,
(select shopid,parentid,shopcode from s_shop where shoptype=4)d
where d.parentid=c.shopid
and c.parentid=b.shopid
and b.parentid=a.m
and d.shopid=14725) mx
where xx.pcode = cy.pcode
and xx.areacode=mx.shopid
group by xx.areacode,mx.m,mx.shopcode))j)h,
(select areacode,shopid from cz_s_area) l
where h.m=l.shopid)
首先 从最里层的 sql说起：
select a.m,d.shopid,d.shopcode from
(select shopid m,parentid from s_shop where shoptype=1) a,
小弟想问个问题，在SQL Server 2005上，建立主键的同时就会默认在主键上设置聚簇索引，那么能否在一个字段上设置主键和唯一性索引（Unique），但是把聚簇索引设置到另一个字段上？
举个简单的例子，比如我有个表叫TableTest，表里有两个字段，id,date，本来id是主键的，我现在想把聚簇索引设置到date字段上。
我先删除� ......
