{"id":476,"date":"2021-10-25T15:23:14","date_gmt":"2021-10-25T07:23:14","guid":{"rendered":"http:\/\/www.citerp.com.tw\/citwp2\/?p=476"},"modified":"2022-10-13T21:05:29","modified_gmt":"2022-10-13T13:05:29","slug":"sql-alter-table-01","status":"publish","type":"post","link":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/10\/25\/sql-alter-table-01\/","title":{"rendered":"[MS-SQL] ALTER TABLE \u589e\u52a0\u6b04\u4f4d"},"content":{"rendered":"\n

\u589e\u52a0\u6b04\u4f4d (ADD COLUMN)<\/strong><\/p>\n\n\n\n

EX: \u5c0d\u5df2\u5b58\u5728\u7684\u8cc7\u6599\u8868 FAC_Dtl_StrWF \u589e\u52a0\u4e00\u6b04\u4f4d COMStr1<\/p>\n\n\n\n

\nALTER TABLE FAC_Dtl_StrWF ADD COMStr1 NVARCHAR(50)    <\/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\u4efb\u4f55\u60f3\u6cd5\uff0c\u6b61\u8fce\u7559\u8a00\u544a\u77e5  \u8b1d\u8b1d !  <\/p>\n\n\n\n
\n\n\n\n
 \ud83d\udc49[MS-SQL]\u5b57\u4e32\u8655\u7406-\u627e\u5b57\u4e32\u4f4d\u7f6e<\/a><\/p>\n\n\n\n
 \ud83d\udc49[MS-SQL] While \u8ff4\u5708<\/a><\/p>\n\n\n\n\ud83d\udc47\u66f4\u591a\u6587\u7ae0\ud83d\udc47<\/span>\n\n\n
\"[MS-SQL]\u5b57\u4e32\u8655\u7406-\u53bb\u9664\u7a7a\u767d\"\/<\/a><\/div>
<\/i> 2022-01-07<\/span><\/div>
[MS-SQL]\u5b57\u4e32\u8655\u7406-\u53bb\u9664\u7a7a\u767d<\/a><\/h3>
[MS-SQL] \u5b57\u4e32\u53bb\u9664\u7a7a\u767d\u00a0ltrim\u3001rtrim<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"WordPress<\/a><\/div>
<\/i> 2021-07-29<\/span><\/div>
WordPress \u5982\u4f55\u81ea\u8a02\u6a19\u7c64\u96f2\uff08tag cloud\uff09\u7684\u5927\u5c0f\u53ca\u6a23\u5f0f<\/a><\/h3>
WordPress\u5275\u4f5c\u81ea\u5df1\u559c\u6b61\u7684\u6a19\u7c64\u96f2\uff08tag cloud\uff09\u6a23\u5f0f<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"Visual<\/a><\/div>
<\/i> 2021-12-22<\/span><\/div>
Visual Studio Code (\u00a0VS Code) \u5b89\u88dd\u6559\u5b78(\u4f7f\u7528Python)<\/a><\/h3>
Visual Studio Code\uff08\u7c21\u7a31\u00a0VS Code\uff09\u662f\u4e00\u6b3e\u7531\u5fae\u8edf\u958b\u767c\u4e14\u8de8\u5e73\u53f0\u7684\u514d\u8cbb\u539f\u59cb\u78bc\u7de8\u8f2f\u5668\uff0c\u53ea\u8981\u88dd\u4e0a\u5c0d\u61c9\u8a9e\u8a00\u7684\u5ef6\u4f38\u5916\u639b\u6a21\u7d44(Extensions)\uff0c\u5373\u53ef\u8b8a\u6210IDE\u7684\u958b\u767c\u74b0\u5883\uff0c\u80fd\u8f15\u9b06\u64b0\u5bebPython\u3001Java\u3001PHP\u3001HTML\u7b49\u7a0b\u5f0f\u8a9e\u8a00\u3002<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u4f7f\u7528quotename()\u8fd4\u56de\u6dfb\u52a0\u4ecb\u5b9a\u754c\u7b26\u865f\u7684Unicode\u5b57\u7b26\u4e32\"\/<\/a><\/div>
<\/i> 2022-06-30<\/span><\/div>
[MS-SQL]\u4f7f\u7528quotename()\u8fd4\u56de\u6dfb\u52a0\u4ecb\u5b9a\u754c\u7b26\u865f\u7684Unicode\u5b57\u7b26\u4e32<\/a><\/h3>
\u4f7f\u7528quotename()\u51fd\u6578\uff0c\u53ef\u8fd4\u56de\u6dfb\u52a0\u4ecb\u5b9a\u754c\u7b26\u865f\u7684Unicode\u5b57\u7b26\u4e32\uff0c\u4ecb\u5b9a\u754c\u7b26\u865f\u53ef\u4ee5\u662f\u55ae\u5f15\u865f(&#821 … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"\u5728<\/a><\/div>
<\/i> 2022-06-29<\/span><\/div>
\u5728 cPanel \u5efa\u7acb MySQL \u8cc7\u6599\u5eab                  \u53ca\u67b6\u8a2d WordPress \u7db2\u7ad9(\u4e8c)<\/a><\/h3>
\u5728\u4e0a\u4e00\u7bc7\u6211\u5011\u5efa\u7acb\u4e86\u8cc7\u6599\u5eab\uff0c\u4e5f\u5efa\u7acb\u4e86\u8981\u5b58\u653eWordPress\u7684\u8cc7\u6599\u593e\u3002\u63a5\u4e0b\u4f86\u5c31\u8981\u4ecb\u7d39\u5982\u4f55\u5b89\u88ddWordpress\u7db2 … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"PHPMyAdmin<\/a><\/div>
<\/i> 2021-12-19<\/span><\/div>
PHPMyAdmin \u6559\u5b78(MySQL\u67e5\u8a62\u8cc7\u6599\u8868)<\/a><\/h3>
PHPMyAdmin \u6559\u5b78(MySQL\u67e5\u8a62\u8cc7\u6599\u8868)<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"\u5728<\/a><\/div>
<\/i> 2022-06-29<\/span><\/div>
\u5728 cPanel \u5efa\u7acb MySQL \u8cc7\u6599\u5eab                  \u53ca\u67b6\u8a2d WordPress \u7db2\u7ad9(\u4e00)<\/a><\/h3>
cPanel\u662f\u4e00\u500b\u591a\u6578\u4eba\u5e38\u898b\u7684\u865b\u64ec\u4e3b\u6a5f\u7ba1\u7406\u5f8c\u53f0\uff0c\u4f46\u767b\u5165cPanel\u5f8c\u53f0\u5f8c\uff0c\u8981\u5982\u4f55\u5efa\u7acbMySQL\u8cc7\u6599\u5eab\u53ca\u67b6\u8a2dWo … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"XAMPP<\/a><\/div>
<\/i> 2021-07-15<\/span><\/div>
XAMPP \u5b89\u88dd\u6559\u5b78<\/a><\/h3>
XAMPP\u662f\u5b8c\u5168\u514d\u8cbb\u4e14\u6613\u65bc\u5b89\u88dd\u7684Apache\u767c\u884c\u7248\u672c\uff0c\u8207 PHP \u8a9e\u8a00\u3001 Perl \u8a9e\u8a00\u53ca MariaDB \u96c6\u5408\u5728\u4e00\u8d77\u7684\u8edf\u9ad4\u5305\uff0c\u5b83\u5141\u8a31\u7528\u6236\u5728\u81ea\u5df1\u7684\u96fb\u8166\u4e0a\u5efa\u7acb Apache \u7db2\u9801\u4f3a\u670d\u5668\u3002<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"Win10\u5b89\u88ddSQL<\/a><\/div>
<\/i> 2023-03-24<\/span><\/div>
Win10\u5b89\u88ddSQL Server 2005 Express<\/a><\/h3>
\u5728Windows10\u7684\u7b46\u96fb\uff0c\u5b89\u88ddSQL Server 2005 Express\u3002 \u8981\u5148\u88dd t .NET Fra … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"\u8a2d\u5b9a<\/a><\/div>
<\/i> 2021-07-18<\/span><\/div>
\u8a2d\u5b9a WordPress \u7db2\u7ad9\u7684\u5716\u793a (Favicon)<\/a><\/h3>
\u700f\u89bd\u5668\u958b\u555f\u5f88\u591a\u5206\u9801\uff0c\u6bcf\u4e00\u500b\u5206\u9801\u4ee3\u8868\u4e00\u500b\u7db2\u9801\uff0c\u5206\u9801\u4e0a\u65b9\u6709\u7db2\u9801\u7684\u6a19\u984c\uff0c\u6a19\u984c\u65c1\u7684\u5c0f\u5716\u793a\u5c31\u662fFavicon \u3002<\/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