读书人

SQL delete,该怎么处理

发布时间: 2012-01-19 20:57:58 作者: rapoo

SQL delete
A表的C字段包含B表的D字段,就删除A表中的这条记录

[解决办法]
奇怪的应用...
Delete From A
Where C in (Select A.C From A, B Where A.C Like '% ' + B.D + '% ')
[解决办法]
delect a from inner join b on a.c like '% '+b.d+ '% '

[解决办法]
delect a from a inner join b on a.c like '% '+b.d+ '% '
[解决办法]
delete from a where c in (select b.d form a,b where a.c like '% ' + b.d + '% ')

读书人网 >C#

热点推荐