{"id":1175,"date":"2022-10-26T10:58:28","date_gmt":"2022-10-26T02:58:28","guid":{"rendered":"https:\/\/aic.leexinghai.com\/?p=1175"},"modified":"2022-10-26T10:58:28","modified_gmt":"2022-10-26T02:58:28","slug":"h21026-%e5%ae%9e%e9%aa%8c4-%e6%95%b0%e6%8d%ae%e6%9f%a5%e8%af%a2%e7%9a%84%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%80%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.leexinghai.com\/aic\/h21026-%e5%ae%9e%e9%aa%8c4-%e6%95%b0%e6%8d%ae%e6%9f%a5%e8%af%a2%e7%9a%84%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%80%ef%bc%89\/","title":{"rendered":"H21026-\u5b9e\u9a8c4-\u6570\u636e\u67e5\u8be2\u7684\u64cd\u4f5c\uff08\u4e00\uff09"},"content":{"rendered":"\n<p>\u4e00\u3001<strong>\u5b9e\u9a8c\u76ee\u7684<\/strong><\/p>\n\n\n\n<p><strong>&nbsp;&nbsp;&nbsp; <\/strong><strong>\u901a\u8fc7\u672c\u5b9e\u9a8c\uff0c\u4f7f\u8bfb\u8005\u5b66\u4f1aSQL\u8bed\u8a00SELECT\u8bed\u53e5\u7684\u57fa\u672c\u4f7f\u7528\u65b9\u6cd5\uff0c\u719f\u7ec3\u638c\u63e1\u5355\u8868\u67e5\u8be2\u3001\u5206\u7ec4\u67e5\u8be2\u3001\u805a\u96c6\u51fd\u6570\u67e5\u8be2\u548c\u67e5\u8be2\u7ed3\u679c\u6392\u5e8f\uff0c\u5b66\u4f1a\u6570\u636e\u7684\u5bfc\u5165\u4e0e\u5bfc\u51fa\u7684\u65b9\u6cd5\u3002<\/strong><\/p>\n\n\n\n<p><strong>\u4e8c\u3001\u5b9e\u9a8c\u4eea\u5668\u8bbe\u5907\u3001\u8bd5\u5242\u6216\u6750\u6599<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>\u4f7f\u7528<\/strong><strong>SQL Server 2008<\/strong><strong>\u8f6f\u4ef6\u8fdb\u884c\u5b9e\u9a8c\u64cd\u4f5c\u3002<\/strong><strong><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>\u5b9e\u9a8c\u8981\u6c42<\/strong><\/li><\/ul>\n\n\n\n<p><strong>&nbsp;&nbsp;&nbsp; <\/strong><strong>\u521b\u5efa\u4e00\u4e2a\u540d\u4e3alianxi1\u7684\u6570\u636e\u5e93\uff0c\u5728\u8be5\u6570\u636e\u5e93\u4e2d\u5bfc\u5165\u4ed3\u5e93\u8868\u548c\u804c\u5de5\u8868\u3002\u5b8c\u6210\u6307\u5b9a\u7684\u67e5\u8be2\u64cd\u4f5c\uff0c\u719f\u7ec3\u638c\u63e1\u5355\u8868\u7684\u5168\u90e8\u67e5\u8be2\u3001\u6307\u5b9a\u5217\u67e5\u8be2\u3001\u53d6\u6d88\u91cd\u590d\u884c\u67e5\u8be2\u3001\u52a0\u522b\u540d\u67e5\u8be2\u3001\u6ee1\u8db3\u7ed9\u5b9a\u6761\u4ef6\u7684\u67e5\u8be2\u3001\u5206\u7ec4\u67e5\u8be2\u3001\u805a\u96c6\u51fd\u6570\u67e5\u8be2\u3001\u7ed3\u679c\u6392\u5e8f\u7b49\u67e5\u8be2\u3002<\/strong><\/p>\n\n\n\n<p><strong>\u56db\u3001\u5b9e\u9a8c\u5185\u5bb9\u4e0e\u6b65\u9aa4<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li><strong>\u521b\u5efa\u4ed3\u5e93\u8868\uff0c\u9996\u5148\u521b\u5efa\u6570\u636e\u5e93[lianxi1],\u5982\u56fe1\u6240\u793a\u3002<\/strong><\/li><\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"702\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-85.png\" alt=\"\" class=\"wp-image-1185\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-85.png 800w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-85-300x263.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-85-768x674.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption>\u56fe1<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>1.1<\/strong><strong>\u5b8c\u6210\u521b\u5efa\u540e\uff0c\u5728\u6570\u636e\u5e93\u4f4d\u7f6e\u53f3\u952e<\/strong><strong>\u201c<\/strong><strong>\u4efb\u52a1<\/strong><strong>\u201d<\/strong><strong>-&gt;<\/strong><strong>\u5bfc\u5165\u6570\u636e\uff0c\u6570\u636e\u6e90\u4e2d\u9009\u62e9<\/strong><strong>\u201c<\/strong><strong>Microsoft Excel<\/strong><strong>\u201d<\/strong><strong>\uff0c\u5982\u56fe2\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"805\" height=\"597\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-86.png\" alt=\"\" class=\"wp-image-1186\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-86.png 805w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-86-300x222.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-86-768x570.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><figcaption>\u56fe2<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>1.2<\/strong><strong>\u76ee\u6807\u9009\u62e9<\/strong><strong>\u201c<\/strong><strong>SQLSNC11.0<\/strong><strong>\u201d<\/strong><strong>\u5982\u56fe3\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"621\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-87.png\" alt=\"\" class=\"wp-image-1187\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-87.png 708w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-87-300x263.png 300w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><figcaption>\u56fe3<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>1.3<\/strong><strong>\u5728\u4e0b\u4e00\u6b65\u7684<\/strong><strong>\u201c<\/strong><strong>\u76ee\u6807<\/strong><strong>\u201d<\/strong><strong>\u5c06[dbo].[***]\u4fee\u6539\u4e3a\u201c\u4ed3\u5e93\u8868\u201d\u3002\u5982\u56fe4\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"759\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-88.png\" alt=\"\" class=\"wp-image-1189\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-88.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-88-300x263.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-88-768x674.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe4<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li><strong>\u521b\u5efa\u804c\u5de5\u8868\uff0c\u6b65\u9aa4\u53ef\u4ee5\u53c2\u8003\u7b2c\u4e00\u6b65\u3002\u5bfc\u5165\u5b8c\u6210\u540e\u5982\u56fe5\u6240\u793a\u3002<\/strong><\/li><\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"309\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-89.png\" alt=\"\" class=\"wp-image-1190\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-89.png 397w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-89-300x234.png 300w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><figcaption>\u56fe5<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>3<\/strong><strong>\u3001\u7528SQL\u8bed\u53e5\u5b8c\u6210\u4ee5\u4e0b\u67e5\u8be2<\/strong><\/p>\n\n\n\n<p><strong>&nbsp;<\/strong><strong>\uff081\uff09\u3001\u4ece\u804c\u5de5\u5173\u7cfb\u4e2d\u68c0\u7d22\u6240\u6709\u6708\u5de5\u8d44\u503c\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe6\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"854\" height=\"673\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-90.png\" alt=\"\" class=\"wp-image-1191\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-90.png 854w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-90-300x236.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-90-768x605.png 768w\" sizes=\"auto, (max-width: 854px) 100vw, 854px\" \/><figcaption>\u56fe6<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>&nbsp;<\/strong><strong>\uff082\uff09\u3001\u68c0\u7d22\u4ed3\u5e93\u5173\u7cfb\u4e2d\u7684\u6240\u6709\u5143\u7ec4\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe7\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"475\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-91.png\" alt=\"\" class=\"wp-image-1192\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-91.png 594w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-91-300x240.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><figcaption>\u56fe7<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>&nbsp;<\/strong><strong>\uff083\uff09\u3001\u68c0\u7d22\u6708\u5de5\u8d44\u591a\u4e8e2000\u5143\u7684\u804c\u5de5\u5bf9\u5e94\u7684\u804c\u5de5\u53f7\u3001\u59d3\u540d\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe8\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"233\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-92.png\" alt=\"\" class=\"wp-image-1193\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-92.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-92-300x81.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-92-768x207.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe8<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff084\uff09\u3001\u68c0\u7d22\u54ea\u4e9b\u4ed3\u5e93\u7684\u9762\u79ef\u4e3a400~500\u33a1\uff0c\u5217\u51fa\u4ed3\u5e93\u53f7\u548c\u6240\u5728\u7684\u57ce\u5e02\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe9\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"137\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-93.png\" alt=\"\" class=\"wp-image-1194\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-93.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-93-300x48.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-93-768x122.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe9<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff085\uff09\u3001\u68c0\u7d22\u51fa\u5e7f\u5dde\u6709\u54ea\u4e9b\u4ed3\u5e93\uff0c\u5217\u51fa\u4ed3\u5e93\u53f7\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe10\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"239\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-94.png\" alt=\"\" class=\"wp-image-1195\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-94.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-94-300x83.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-94-768x212.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe10<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff086\uff09\u3001\u68c0\u7d22\u51fa\u6240\u5728\u57ce\u5e02\u4e3a\u5e7f\u5dde\u7684\u4ed3\u5e93\u7684\u4e2a\u6570\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe11\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"162\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-95.png\" alt=\"\" class=\"wp-image-1196\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-95.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-95-300x56.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-95-768x144.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe11<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff087\uff09\u3001\u68c0\u7d22\u51fa\u6240\u6709\u804c\u5de5\u7684\u5e73\u5747\u5de5\u8d44\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe12\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"169\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-96.png\" alt=\"\" class=\"wp-image-1197\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-96.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-96-300x59.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-96-768x150.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe12<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff088\uff09\u3001\u68c0\u7d22\u51fa\u5728WH5\u4ed3\u5e93\u5de5\u4f5c\u7684\u804c\u5de5\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe13\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"242\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-97.png\" alt=\"\" class=\"wp-image-1198\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-97.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-97-300x84.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-97-768x215.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe13<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff089\uff09\u3001\u68c0\u7d22\u51fa\u804c\u5de5\u8868\u4e2d\u6240\u6709\u7684\u4ed3\u5e93\u53f7\uff0c\u53bb\u6389\u91cd\u590d\u503c\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe14\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"759\" height=\"405\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-98.png\" alt=\"\" class=\"wp-image-1199\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-98.png 759w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-98-300x160.png 300w\" sizes=\"auto, (max-width: 759px) 100vw, 759px\" \/><figcaption>\u56fe14<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff0810\uff09\u3001\u68c0\u7d22\u51fa\u6bcf\u4e2a\u4ed3\u5e93\u7684\u4eba\u6570\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe15\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"321\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-99.png\" alt=\"\" class=\"wp-image-1200\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-99.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-99-300x111.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-99-768x285.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe15<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff0811\uff09\u3001\u68c0\u7d22\u51fa\u4e0a\u6d77\u7684\u4ed3\u5e93\u6709\u54ea\u4e9b\uff0c\u5217\u51fa\u4ed3\u5e93\u53f7\u3001\u9762\u79ef\u3002\u67e5\u8be2\u7ed3\u679c\u6309\u9762\u79ef\u964d\u5e8f\u6392\u5217\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe16\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"168\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-100.png\" alt=\"\" class=\"wp-image-1201\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-100.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-100-300x58.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-100-768x149.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe16<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff0812\uff09\u3001\u68c0\u7d22\u51fa\u54ea\u4e9b\u4ed3\u5e93\u5973\u804c\u5de5\u7684\u4eba\u6570\u8fbe\u5230\u4e863\u4eba\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe17\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"102\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-101.png\" alt=\"\" class=\"wp-image-1202\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-101.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-101-300x35.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-101-768x91.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe17<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff0813\uff09\u3001\u68c0\u7d22\u51fa\u6240\u6709\u59d3\u80e1\u7684\u804c\u5de5\u7684\u804c\u5de5\u53f7\u3001\u59d3\u540d\u3001\u6027\u522b\u3001\u6708\u5de5\u8d44\u3002\u67e5\u8be2\u7ed3\u679c\u6309\u6027\u522b\u6392\u964d\u5e8f\u3001\u6708\u5de5\u8d44\u6392\u5347\u5e8f\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe18\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"198\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-102.png\" alt=\"\" class=\"wp-image-1203\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-102.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-102-300x69.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-102-768x176.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe18<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff0814\uff09\u3001\u68c0\u7d22\u51fa\u804c\u5de5\u201c\u738b\u739b\u4e3d\u201d\u7684\u5e74\u5de5\u8d44\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe19\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"148\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-103.png\" alt=\"\" class=\"wp-image-1204\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-103.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-103-300x51.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-103-768x131.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe19<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff0815\uff09\u3001\u68c0\u7d22\u51fa\u5728WH1\u548cWH2\u4e24\u4e2a\u4ed3\u5e93\u5de5\u4f5c\u7684\u804c\u5de5\u7684\u57fa\u672c\u4fe1\u606f\uff1b\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe20\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"189\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-104.png\" alt=\"\" class=\"wp-image-1205\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-104.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-104-300x66.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-104-768x168.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe20<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\uff0816\uff09\u3001\u68c0\u7d22\u51fa\u5e74\u5de5\u8d44\u572824000\u5143\u4ee5\u4e0a\u7684\u804c\u5de5\u7684\u59d3\u540d\u3001\u5e74\u5de5\u8d44\u503c\u3002\u547d\u4ee4\u548c\u8fd0\u884c\u7ed3\u679c\u5982\u56fe21\u6240\u793a\u3002<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"865\" height=\"213\" src=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-105.png\" alt=\"\" class=\"wp-image-1206\" srcset=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-105.png 865w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-105-300x74.png 300w, https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/image-105-768x189.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><figcaption>\u56fe21<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\u4e94\u3001\u5b9e\u9a8c\u7ed3\u679c\u4e0e\u5206\u6790<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>&nbsp; <\/strong><strong>\u901a\u8fc7\u7ec3\u4e60\u53ef\u4ee5\u638c\u63e1SQL SERVER2008\u7684\u67e5\u8be2\u65b9\u6cd5\u3002<\/strong><\/p>\n\n\n\n<p><strong>\u516d\u3001\u7ed3\u8bba\u4e0e\u4f53\u4f1a<\/strong><strong><\/strong><\/p>\n\n\n\n<p>&nbsp; <strong>\u901a\u8fc7\u672c\u5b9e\u9a8c\uff0c\u53ef\u4ee5\u5b66\u4f1aSQL\u8bed\u8a00SELECT\u8bed\u53e5\u7684\u57fa\u672c\u4f7f\u7528\u65b9\u6cd5\uff0c\u719f\u7ec3\u638c\u63e1\u5355\u8868\u67e5\u8be2\u3001\u5206\u7ec4\u67e5\u8be2\u3001\u805a\u96c6\u51fd\u6570\u67e5\u8be2\u548c\u67e5\u8be2\u7ed3\u679c\u6392\u5e8f\uff0c\u5b66\u4f1a\u6570\u636e\u7684\u5bfc\u5165\u4e0e\u5bfc\u51fa\u7684\u65b9\u6cd5\u3002<\/strong><\/p>\n\n\n\n<p>\u6570\u636e\u5e93\u8d44\u6e90\u4e0b\u8f7d\uff1a<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-d4cfa7d1-ecba-456c-b59e-88a84a73c64a\" href=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/\u6570\u636e\u5e93\u8d44\u6e90.7z\">\u6570\u636e\u5e93\u8d44\u6e90<\/a><a href=\"https:\/\/www.leexinghai.com\/aic\/wp-content\/uploads\/2022\/10\/\u6570\u636e\u5e93\u8d44\u6e90.7z\" class=\"wp-block-file__button\" download aria-describedby=\"wp-block-file--media-d4cfa7d1-ecba-456c-b59e-88a84a73c64a\">\u4e0b\u8f7d<\/a><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u5b9e\u9a8c\u76ee\u7684 &nbsp;&nbsp;&nbsp; \u901a\u8fc7\u672c\u5b9e\u9a8c\uff0c\u4f7f\u8bfb\u8005\u5b66\u4f1aSQL\u8bed\u8a00SELECT\u8bed\u53e5\u7684\u57fa\u672c\u4f7f\u7528 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1176,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-1175","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dtba"],"_links":{"self":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/posts\/1175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/comments?post=1175"}],"version-history":[{"count":0,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/posts\/1175\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/media?parent=1175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/categories?post=1175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/tags?post=1175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}