在编辑导向中输入如下的语句,测试通过:
SELECT ID, InputDate, ArriveCompany, Event, InputMan, Term, Complete, CompleteDate, CompleteDesc, Re, InputOffice FROM tWorkLog where (ArriveCompany like @strSearch + '%')请问能不能设置成这样的语句:
SELECT ID, InputDate, ArriveCompany, Event, InputMan, Term, Complete, CompleteDate, CompleteDesc, Re, InputOffice FROM tWorkLog where (@这里的字段名也是读取来的 like @strSearch + '%')
或者设置成这样的语句:
SELECT ID, InputDate, ArriveCompany, Event, InputMan, Term, Complete, CompleteDate, CompleteDesc, Re, InputOffice FROM tWorkLog where (@这里的字段名时读取来的 @这里的符号也是读取来的 @strSearch + '%')
SELECT ID, InputDate, ArriveCompany, Event, InputMan, Term, Complete, CompleteDate, CompleteDesc, Re, InputOffice FROM tWorkLog where (ArriveCompany like @strSearch + '%')请问能不能设置成这样的语句:
SELECT ID, InputDate, ArriveCompany, Event, InputMan, Term, Complete, CompleteDate, CompleteDesc, Re, InputOffice FROM tWorkLog where (@这里的字段名也是读取来的 like @strSearch + '%')
或者设置成这样的语句:
SELECT ID, InputDate, ArriveCompany, Event, InputMan, Term, Complete, CompleteDate, CompleteDesc, Re, InputOffice FROM tWorkLog where (@这里的字段名时读取来的 @这里的符号也是读取来的 @strSearch + '%')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货