A id title
1 abc
2 def
3 cdsB id key
1 a
2 d
3 g现在要查出A中title中所有含有key字段的信息 如:如果是a 就查询到
1 abc
如果是d 查询到:
1 def
2 cds这种情况sql语句怎么写?
1 abc
2 def
3 cdsB id key
1 a
2 d
3 g现在要查出A中title中所有含有key字段的信息 如:如果是a 就查询到
1 abc
如果是d 查询到:
1 def
2 cds这种情况sql语句怎么写?
Select A.* From A Inner Join B On A.title Like '%' + B.[key] + '%' Where A.[key] = 'a'
Select A.* From A Inner Join B On A.title Like '%' + B.[key] + '%' Where A.[key] = 'd'
Select A.* From A Inner Join B On CharIndex(B.[key], A.title) > 0 Where A.[key] = 'a'
Select A.* From A Inner Join B On CharIndex(B.[key], A.title) > 0 Where A.[key] = 'd'
insert A
select 1,'abc' union all
select 2,'def' union all
select 3,'cds' create table B ( id int, skey varchar(10))
insert B
select 1,'a' union all
select 2,'d' union all
select 3,'g' select B.skey,A.* from B,A where charindex(B.skey,A.title)>0 drop table A
drop table B
---------- ----------- ----------
a 1 abc
d 2 def
d 3 cds
這個意思?
Select A.* From A Inner Join B On A.title Like '%' + B.[key] + '%' Where A.[key] = 'a'
Select A.* From A Inner Join B On A.title Like '%' + B.[key] + '%' Where A.[key] = 'd'
====================================================
正解```这样也可以````
Select A.* From A Inner Join B On A.title Like '%' + B.[key] + '%'
如果是删除这些查询出来的信息呢,该怎么写?
inner join tableB as b on charindex(b.[key],a.title) > 0
Delete A.* From A Inner Join B On A.title Like '%' + B.[key] + '%' Where A.[key] = 'd'
to caibaoying(为了泡妞学SQL~~~)
如果是删除这些查询出来的信息呢,该怎么写?
------------------------上面錯了Delete A From A Inner Join B On A.title Like '%' + B.[key] + '%' Where A.[key] = 'a'
Delete A From A Inner Join B On A.title Like '%' + B.[key] + '%' Where A.[key] = 'd'
Delete A From A Inner Join B On CharIndex(B.[key], A.title) > 0 Where A.[key] = 'd'