create table 表1
(
id int,
da varchar(10)
)
go
insert into 表1 values(1,'AB')
insert into 表1 values(2,'AC')
insert into 表1 values(3, 'B')
insert into 表1 values(4, 'BC')
go
create table 表2
(
id int,
ckda varchar(10),
fz int
)
go
insert into 表2 values(1,'AB',5)
insert into 表2 values(2,'ABC',5 )
insert into 表2 values(3,'ABCD',5)
insert into 表2 values(4,'AC',5)
go
Select *,Case
When Exists(Select '' From 表2 Where 表1.id=表2.id And 表1.da=表2.ckda) Then 5
When Exists
(
Select '' From
(
Select SUBSTRING(da,number,1) as da From 表1 A Cross Join
(
Select number From master.dbo.spt_values
Where type='P' And number Between 1 And 4
) B Where id=表1.id
) M Where da<>'' And da Not In
(
Select SUBSTRING(ckda,number,1) as ckda From 表2 A Cross Join
(
Select number From master.dbo.spt_values
Where type='P' And number Between 1 And 4
) B Where id=表1.id)
) Then 0 Else 2 End df
From 表1
第1题完全正确得5分
第2,3部分正确得2分
第4题包含错误答案得0分
你不是在百度问问采纳了么,害得我答案写好了,都没得回答
