Hi everybody !I'' d like to check data before inserting.Select @nb = Count (idCustomer)From CustomerWhere company like ''%'' + @company+ ''%''If "PEUGEOT SA" already exists, @nb > 0 if I enter "PEUGEOT".On the other hand, if "PEUGEOT" exists, @nb =0 if I enter "PEUGEOT SA".I tried to complete ma stored procedure:or @companylike ''%'' + company+ ''%''but it doesn''t work.Thanks in advance for any suggestion. 解决方案 这篇关于检查现有数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
09-10 23:01