mysql转sqlserver的sql语句
mysql函数中concat在sqlserver函数中怎么用
例如$sql.= " and concat(bs.custom_addr_province,bs.custom_addr_city,bs.custom_addr_detail) like '%".$searchcondition["custom_addr"]."%'"; MySQL SQL SQL?Server
[解决办法]
and concat(bs.custom_addr_province,bs.custom_addr_city,bs.custom_addr_detail)→and bs.custom_addr_province+bs.custom_addr_city+bs.custom_addr_detail