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条不行.
相关阅读
考MCDBA还是ORACLE的证书？can i do this in crystal report?database overflowQuery 优化的问题SQL 问题 [zz]AW and Shuke Re: Can I...oracle db connection through firewallMicrosoft 的MCDBA certificate 对找工作有多大帮助？database search engineNeed help on VBA! Please!VBA FOR EXCEL 问题请教，ONLINE WAITINGHow to customize dialog box in MS ACCESSPerl安装DBD::oracle的问题(linux,server不在本机）请教一个关于JDBC的问题，实在太烦了！请问哪里有sql语句追踪工具unixODBC推荐本好的DATABASE 教材偶想安装oraclehelp on Oracle please明白Re: AW and Shuke Re: Can I...