select * from ph WHERE db='331' AND (dh='080001' or dh='080002')
create table ph ( phid int primary key identity, db nvarchar(20), dh nvarchar(20), ph nvarchar(20) ) insert into ph(db,dh,ph) values('331','080001','08000101') insert into ph(db,dh,ph) values('331','080001','08000102') insert into ph(db,dh,ph) values('331','080001','08000103') insert into ph(db,dh,ph) values('331','080002','08000201') insert into ph(db,dh,ph) values('331','080003','08000301') insert into ph(db,dh,ph) values('332','080001','08000101') insert into ph(db,dh,ph) values('332','080001','08000102') insert into ph(db,dh,ph) values('332','080002','08000201') insert into ph(db,dh,ph) values('333','080001','08000101') insert into ph(db,dh,ph) values('333','080001','08000102') insert into ph(db,dh,ph) values('333','080002','08000201') insert into ph(db,dh,ph) values('334','080001','08000101') insert into ph(db,dh,ph) values('334','080001','08000102') insert into ph(db,dh,ph) values('334','080002','08000201') select * from ph where db='331' and (dh='080001' or dh='080002') go drop table ph /* phid db dh ph ----------- -------------------- -------------------- -------------------- 1 331 080001 08000101 2 331 080001 08000102 3 331 080001 08000103 4 331 080002 08000201(4 行受影响)*/
WHERE db='331' AND (dh='080001' or dh='080002')
(
phid int primary key identity,
db nvarchar(20),
dh nvarchar(20),
ph nvarchar(20)
)
insert into ph(db,dh,ph) values('331','080001','08000101')
insert into ph(db,dh,ph) values('331','080001','08000102')
insert into ph(db,dh,ph) values('331','080001','08000103')
insert into ph(db,dh,ph) values('331','080002','08000201')
insert into ph(db,dh,ph) values('331','080003','08000301')
insert into ph(db,dh,ph) values('332','080001','08000101')
insert into ph(db,dh,ph) values('332','080001','08000102')
insert into ph(db,dh,ph) values('332','080002','08000201')
insert into ph(db,dh,ph) values('333','080001','08000101')
insert into ph(db,dh,ph) values('333','080001','08000102')
insert into ph(db,dh,ph) values('333','080002','08000201')
insert into ph(db,dh,ph) values('334','080001','08000101')
insert into ph(db,dh,ph) values('334','080001','08000102')
insert into ph(db,dh,ph) values('334','080002','08000201')
select * from ph where db='331' and (dh='080001' or dh='080002')
go
drop table ph
/*
phid db dh ph
----------- -------------------- -------------------- --------------------
1 331 080001 08000101
2 331 080001 08000102
3 331 080001 08000103
4 331 080002 08000201(4 行受影响)*/
------------
这么说可以有两种理解,楼主最好把想要的结果贴上来看看,比较直观。
where db=N'331' and (dh=N'080001' or dh=N'080002')
结果:
15 331 080001 08000101
16 331 080001 08000102
17 331 080001 08000103
18 331 080002 08000201
where rtrim(db) = '331'
and (rtrim(dh) = '080001' or rtrim(dh) = '080002')
where rtrim(db) = '331'
and (rtrim(dh) = '080001' or rtrim(dh) = '080002')