{"id":226,"date":"2021-07-20T21:49:42","date_gmt":"2021-07-20T13:49:42","guid":{"rendered":"http:\/\/www.citerp.com.tw\/citwp2\/?p=226"},"modified":"2022-10-13T20:59:18","modified_gmt":"2022-10-13T12:59:18","slug":"sql-date2-01","status":"publish","type":"post","link":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/20\/sql-date2-01\/","title":{"rendered":"[MS-SQL] \u897f\u5143\u65e5\u671f\u8f49\u6210\u6c11\u570b\u65e5\u671f"},"content":{"rendered":"\n

\u5c07\u897f\u5143\u65e5\u671f\u8f49\u6c11\u570b\u65e5\u671f<\/strong> 2011\/10\/05 –> 100\/10\/05<\/p>\n\n\n\n

EX: 2011\/10\/05 –> 100\/10\/05<\/p>\n\n\n\n

\nSELECT CONVERT(VARCHAR(3),CONVERT(VARCHAR(4),Chgdate,20) - 1911) + '\/' +\n           SUBSTRING(CONVERT(VARCHAR(10),Chgdate,20),6,2) + '\/' +\n           SUBSTRING(CONVERT(VARCHAR(10),Chgdate,20),9,2) \nFROM (SELECT CAST('2011\/10\/05' AS datetime) Chgdate) A    <\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u5be6\u4f5c:  <\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
 \u5404\u4f4d\u5982\u679c\u6709\u66f4\u597d\u7684\u5beb\u6cd5\uff0c\u6b61\u8fce\u7559\u8a00\u544a\u77e5  \u8b1d\u8b1d !  <\/p>\n\n\n\n
\n\n\n\n
 \ud83d\udc49[MS-SQL] While \u8ff4\u5708<\/a><\/p>\n\n\n\n
 \ud83d\udc49[MS-SQL] ALTER TABLE \u589e\u52a0\u6b04\u4f4d<\/a><\/p>\n\n\n\n\ud83d\udc47\u66f4\u591a\u6587\u7ae0\ud83d\udc47<\/span>\n\n\n
\"[MS-SQL]\u5728\u8cc7\u6599\u5eab\u6240\u6709\u7684\u8cc7\u6599\u8868TABLE\u4e2d\u67e5\u8a62\u95dc\u9375\u5b57\"\/<\/a><\/div>
<\/i> 2022-06-30<\/span><\/div>
[MS-SQL]\u5728\u8cc7\u6599\u5eab\u6240\u6709\u7684\u8cc7\u6599\u8868TABLE\u4e2d\u67e5\u8a62\u95dc\u9375\u5b57<\/a><\/h3>
\u7576\u6709\u4e9b\u6642\u5019\u5982\u679c\u8981\u77e5\u9053\u8cc7\u6599\u5eab\u6240\u6709\u7684TABLE\u4e2d\uff0c\u54ea\u4e9b\u6b04\u4f4d\u7684\u503c\u6709\u95dc\u9375\u5b57\u5728\u5176\u4e2d\uff0c\u4e0b\u9762\u9019\u6bb5\u7a0b\u5f0f\u78bc\u53ef\u4ee5\u9054\u6210\u3002 \ud83d\udc49[MS- … \u95b1\u8b80\u66f4\u591a<\/a><\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"\u5728<\/a><\/div>
<\/i> 2021-12-22<\/span><\/div>
\u5728 Visual Studio Code \u64b0\u5beb\u7b2c\u4e00\u652fPython\u7a0b\u5f0f<\/a><\/h3>
\u5728 Visual Studio Code \u64b0\u5beb\u7b2c\u4e00\u652fPython\u7a0b\u5f0f<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u5efa\u7acb\u8cc7\u6599\u8868\u683c<\/a><\/div>
<\/i> 2022-10-18<\/span><\/div>
[MS-SQL]\u5efa\u7acb\u8cc7\u6599\u8868\u683c CREATE TABLE<\/a><\/h3>
\u8cc7\u6599\u8868\u683c\u662f\u8cc7\u6599\u5eab\u4e2d\u5132\u5b58\u8cc7\u6599\u7684\u57fa\u672c\u67b6\u69cb\uff0c\u6240\u4ee5\u901a\u5e38\u60a8\u6703\u9700\u8981\u81ea\u5df1\u5728\u8cc7\u6599\u5eab\u4e2d\u5efa\u7acb\u8cc7\u6599\u8868\u683c\u3002\u7576\u6211\u5011\u7528Create Tab … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"WordPress<\/a><\/div>
<\/i> 2021-07-26<\/span><\/div>
WordPress \u5916\u639bYoast SEO\u5982\u4f55\u66f4\u6539\u5206\u4eab\u5230LINE\u3001facebook \u7db2\u5740\u7684\u7c21\u4ecb\u5167\u5bb9\uff1f<\/a><\/h3>
\u4f7f\u7528\u5916\u639bYoast SEO\u628a\u7db2\u5740\u5206\u4eab\u5230LINE\u3001\u81c9\u66f8\u6642\uff0c\u7c21\u4ecb\u5167\u5bb9\u7684\u4fee\u6539<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER()\"\/<\/a><\/div>
<\/i> 2022-11-05<\/span><\/div>
[MS-SQL]\u5206\u7fa4\u7d44\u6392\u5e8fROW_NUMBER()<\/a><\/h3>
MSSQL \u9664\u4e86 ORDER BY \u6392\u5e8f\u5916\uff0c\u6211\u5011\u9084\u53ef\u4ee5\u7528 ROW_NUMBER() \uff0c\u914d\u5408 PARTITION … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]<\/a><\/div>
<\/i> 2021-07-30<\/span><\/div>
[MS-SQL] \u897f\u5143\u65e5\u671f\u8f49\u6210\u6c11\u570b\u65e5\u671f<\/a><\/h3>
\u897f\u5143\u65e5\u671f\u8f49\u6210\u6c11\u570b\u65e5\u671f 2011\/10\/05 –> 1001005<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u5b57\u4e32\u8655\u7406-\u627e\u5b57\u4e32\u4f4d\u7f6e\"\/<\/a><\/div>
<\/i> 2022-09-08<\/span><\/div>
[MS-SQL]\u5b57\u4e32\u8655\u7406-\u627e\u5b57\u4e32\u4f4d\u7f6e<\/a><\/h3>
\u5728\u5b57\u4e32\u4e2d\u641c\u5c0b\u7279\u5b9a\u5b50\u5b57\u4e32\u51fa\u73fe\u4f4d\u7f6e CHARINDEX CHARINDEX -> \u641c\u5c0b\u5b50\u5b57\u4e32\u51fa\u73fe\u4f4d\u7f6e \u8a9e\u6cd5\uff1a … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u4e2dROUND\u3001CEILING\u3001FLOOR<\/a><\/div>
<\/i> 2022-06-13<\/span><\/div>
[MS-SQL]\u4e2dROUND\u3001CEILING\u3001FLOOR \u51fd\u6578<\/a><\/h3>
\u56db\u6368\u4e94\u5165\u5230\u6574\u6578\u3001\u7121\u689d\u4ef6\u6368\u53bb\u5230\u6574\u6578\u3001\u7121\u689d\u4ef6\u9032\u4f4d\u5230\u6574\u6578\u7684\u51fd\u6578 \u3002 ROUND() -> \u7528\u4f86\u5c0d\u6578\u503c\u6b04\u4f4d\u503c\u9032\u884c … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u4f7f\u7528CONVERT\u8f49\u63db\u6642\u9593\u683c\u5f0fDatetime\"\/<\/a><\/div>
<\/i> 2022-06-30<\/span><\/div>
[MS-SQL]\u4f7f\u7528CONVERT\u8f49\u63db\u6642\u9593\u683c\u5f0fDatetime<\/a><\/h3>
CONVERT\u80fd\u5c07\u6642\u9593\u683c\u5f0fDatetime\uff0c\u8f49\u63db\u6210\u591a\u7a2eVarchar\u578b\u614b\u7684\u683c\u5f0f\u3002 \ud83d\udc49[MS-SQL]\u4f7f\u7528quo … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u5b57\u4e32\u8655\u7406-\u5927\u5c0f\u5beb\u8f49\u63db\"\/<\/a><\/div>
<\/i> 2022-01-06<\/span><\/div>
[MS-SQL]\u5b57\u4e32\u8655\u7406-\u5927\u5c0f\u5beb\u8f49\u63db<\/a><\/h3>
MS-SQL \u5b57\u4e32\u5927\u5c0f\u5beb\u8f49\u63db\u00a0upper\u3001lower<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><\/div>
1<\/span>\n2<\/a>\n3<\/a>\n…<\/span>\n5<\/a>\nNext <\/span><\/a><\/div><\/div>\n\n\n\n