经典的sql
摘要:以下是一些以前用过的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...
阅读全文
posted @ 2009-07-02 13:58
浙公网安备 33010602011771号