<pre class="c" name="code">Select CONVERT(Date, DA...
<pre class="c" name="code">Select CONVERT(Date, DA...
SELECT CASE “欄位名" WHEN “條件1″ THEN “結果1″ WHEN “條件2″ THEN “結果2″ …. [ELSE &quo...
SELECT CASE “欄位名" WHEN “條件1″ THEN “結果1″ WHEN “條件2″ THEN “結果2″ …. [ELSE &quo...
請參考下篇文章 - 利用 SQL Agent 做工作排程 http://yangxinde.pixnet.net/blog/post/27372053-%E4%...