程序 exec heduling_date_select ' Name like @%a%@ or phone like @%a%@ or Cus_code like @%a%@ or objjc like @%a%@ or Doctor like @%a%@' 存储过程 set @where = replace(@where,'@',char(39))
或者 用两个单引号代替一个 exec heduling_date_select ' Name like ''%a%'' or phone like ''%a%'' or Cus_code like ''%a%'' or objjc like ''%a%'' or Doctor like ''%a%'''