SQL server 2000有hidden records吗?# Database - 数据库
l*u
1 楼
写了一个query对一小部分数据不work,这些数据明明是不符合query的条件.难道有
hidden records? SQL server 2000
hidden records? SQL server 2000
B*g
2 楼
把sql贴出来。
写了一个query对一小部分数据不work,这些数据明明是不符合query的条件.难道有
hidden records? SQL server 2000
【在 l********u 的大作中提到】
: 写了一个query对一小部分数据不work,这些数据明明是不符合query的条件.难道有
: hidden records? SQL server 2000
写了一个query对一小部分数据不work,这些数据明明是不符合query的条件.难道有
hidden records? SQL server 2000
【在 l********u 的大作中提到】
: 写了一个query对一小部分数据不work,这些数据明明是不符合query的条件.难道有
: hidden records? SQL server 2000
l*u
3 楼
说具体点:
I wrote a query it select records from table 1 which has corresponding
records in table 2 and table 3. The query works fine on my machine (server
2005). I moved to clients Server (server 2000), the query works for most
cases, however there a few records get selected even they don't have any
corresponding records in table 2 and table 3 -- run select query on table 2
and 3 returns nothing. We can't figure out why this is happening?
I wrote a query it select records from table 1 which has corresponding
records in table 2 and table 3. The query works fine on my machine (server
2005). I moved to clients Server (server 2000), the query works for most
cases, however there a few records get selected even they don't have any
corresponding records in table 2 and table 3 -- run select query on table 2
and 3 returns nothing. We can't figure out why this is happening?
l*u
4 楼
query 如下:
select distinct prdoco from dbo.f43121 A where
(not exists
(select 1 from dbo.f43121 B where
A.prdoco=b.prdoco
and A.prdcto=b.prdcto
AND A.PRKCOo=B.PRKCOO
and B.PRMATC='2' AND((B.prdoc not in
(SELECT distinct prdoc FROM dbo.f43121, dbo.f0411
where prdoc=rpdoc and prdct=rpdct and prkco=rpkco))
or B.prdoc not in
(SELECT distinct prdoc FROM dbo.f43121, dbo.f0911
where prdoc=gldoc and prdct=gldct and prkco=glkco))))
select distinct prdoco from dbo.f43121 A where
(not exists
(select 1 from dbo.f43121 B where
A.prdoco=b.prdoco
and A.prdcto=b.prdcto
AND A.PRKCOo=B.PRKCOO
and B.PRMATC='2' AND((B.prdoc not in
(SELECT distinct prdoc FROM dbo.f43121, dbo.f0411
where prdoc=rpdoc and prdct=rpdct and prkco=rpkco))
or B.prdoc not in
(SELECT distinct prdoc FROM dbo.f43121, dbo.f0911
where prdoc=gldoc and prdct=gldct and prkco=glkco))))
l*u
5 楼
我觉得query本身不是问题,在我这run的好好的. 但是也想不出client那边有什么猫腻.
怪就怪在客户那边几万条数据,只有那么15条不行.
【在 l********u 的大作中提到】
: query 如下:
: select distinct prdoco from dbo.f43121 A where
: (not exists
: (select 1 from dbo.f43121 B where
: A.prdoco=b.prdoco
: and A.prdcto=b.prdcto
: AND A.PRKCOo=B.PRKCOO
: and B.PRMATC='2' AND((B.prdoc not in
: (SELECT distinct prdoc FROM dbo.f43121, dbo.f0411
: where prdoc=rpdoc and prdct=rpdct and prkco=rpkco))
怪就怪在客户那边几万条数据,只有那么15条不行.
【在 l********u 的大作中提到】
: query 如下:
: select distinct prdoco from dbo.f43121 A where
: (not exists
: (select 1 from dbo.f43121 B where
: A.prdoco=b.prdoco
: and A.prdcto=b.prdcto
: AND A.PRKCOo=B.PRKCOO
: and B.PRMATC='2' AND((B.prdoc not in
: (SELECT distinct prdoc FROM dbo.f43121, dbo.f0411
: where prdoc=rpdoc and prdct=rpdct and prkco=rpkco))
B*g
6 楼
贴一个不行的例子
腻.
【在 l********u 的大作中提到】
: 我觉得query本身不是问题,在我这run的好好的. 但是也想不出client那边有什么猫腻.
: 怪就怪在客户那边几万条数据,只有那么15条不行.
腻.
【在 l********u 的大作中提到】
: 我觉得query本身不是问题,在我这run的好好的. 但是也想不出client那边有什么猫腻.
: 怪就怪在客户那边几万条数据,只有那么15条不行.
相关阅读
关于SCI查询Which server shoule I usemulticolumn primary key ?it did not work. Re: Oracle question. thanks.2000下连接mysql的问题SOS!! Net Logon 服务因 3097 服务性错误而停止Question about Oracle Driver~{8_JVGsVz~}: how to create trigger on a nested table?Oracle 求助certificate? Help please.SQL server & Peer-to-peer networkOracle8i 启动问题oracle trigger questiondatabase evaluationa simpler sQL question, high help please!!!!在ms sql server上的jdbc driver哪个比较好？SQL求救,helpDB2问题向高手请教[转载] Coldfusion and ASP a problem