754
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
tan_na 2001-11-02
- 打赏
- 举报
模糊查询:
strsql = "select * from tablename1 where fieldname like '%string%'"
strsql = strsql+" union all select * from tablename2 where fieldname like '%string%'"......
declare cur_cur1 声明动态SQL语句即可.
strsql = "select * from tablename1 where fieldname like '%string%'"
strsql = strsql+" union all select * from tablename2 where fieldname like '%string%'"......
declare cur_cur1 声明动态SQL语句即可.
sunssc 2001-11-02
- 打赏
- 举报
使用sql:
select * from tabename where fieldname like '%string%';
select * from tabename where fieldname like '%string%';
