官方手册中关于Flush tables的介绍, Closes all open tables, forces all tables in use to be closed, and flushes the query cache. FLUSH TABLES also removes all query results from the query cache, like the RESET QUERY CACHE statement.其解析就是关闭所有已打开的表对象,同时将查询缓存中的结果清空。就是说...【阅读全文】
Not ( a=1 )等于a<>1 Not ( a=1 and b=2 )不等于a<>1 and b<>2等于(a<>1) or(b<>2)Not ( a=1 and b=2 and c=3 )不等于a<>1 and b<>2 and c<>3等于(a<>1) or(b<>2) or(c<>3)Not ( a<>1 and b<>2 and c<>3 )不完全等于a=1 and b=2 and c=3等于(a=1) or(b=2) or(c=3)-=+-=+-=+-=+-=+-=+-=+-=+-=...【阅读全文】
看个sql文的结果select '2015-12-03 23:59:59.999' + ' will stored into db like :' + convert(varchar, convert(datetime, '2015-12-03 23:59:59.999'),121)union allselect '2015-12-03 23:59:59.998' + ' will stored into db like :' + convert(varchar, convert(datetime, '2015-12-...【阅读全文】
https://m.oschina.net/blog/266504感谢星辰~发布于上边的文章收藏下,也许会用到建立正则替换函数,利用了OLE对象,以下是函数代码:IF OBJECT_ID(N'dbo.RegexReplace') IS NOT NULL DROP FUNCTION dbo.RegexReplaceGOCREATE FUNCTION dbo.RegexReplace(@string VARCHAR(MAX),--被替换的字符串@pa...【阅读全文】