随笔分类 -  数据库相关

摘要：以下是一些以前用过的SQL ，总也记不住，就写下来了，有几个很好用，分享一下：1.取年SELECT CreateDate,CAST(YEAR(CreateDate) AS VARCHAR(4)) + '-' + CAST(MONTH(CreateDate) AS VARCHAR(2)) + '-' + CAST(DAY(CreateDate) AS VARCHAR(2)) + char(13)+c... 阅读全文