sdklwq的博客

如果想查找“_cs”结尾的的账户select * from [user] where loginname like '%cs’是不行的， 被认为是任意的字符，所以需要转义字符，有两种写法：select * from [user] where loginname like ‘%[_]cs’select * from [user] where loginname like ‘%/_cs’ escape’/’通配符含义%包含零个或更多字符的任意字符串。_任何单个字符。[ ]指定范围（例如

笔记：换行符 CHAR(10)举例：将换行符改成空格UPDATE dbo.goodsInfo SET goods_name=REPLACE(gModel_color,CHAR(10),’ ‘) WHERE gModel_color LIKE ‘%’+CHAR(10)+’%’;