Supplementary explanation: to run programs written in Delphi, procedures used in the db files can open the use,
Delphi Tquery query used in the where department (like 'A') to check the record, and use the where='A') (department) record number is 0, why?
CodePudding user response:
Where department (like 'A') is approximate matching, where='A' (department) is an exact matchCodePudding user response:
1, the first question you wash not clear,2, the second should be the where (department like '% A %) can register contains A value (SQL server),
Where department (like 'A') and the where='A' (department) of the result is the same,