{"id":18380,"date":"2026-07-19T03:21:45","date_gmt":"2026-07-18T18:21:45","guid":{"rendered":"https:\/\/genai-ai.co.jp\/ai-kanri\/?p=18380"},"modified":"2026-07-19T03:21:45","modified_gmt":"2026-07-18T18:21:45","slug":"cc-ssms-guide","status":"publish","type":"post","link":"https:\/\/genai-ai.co.jp\/ai-kanri\/blog\/cc-ssms-guide\/","title":{"rendered":"\u30102026\u5e747\u6708\u6700\u65b0\u3011SQL Server Management Studio(SSMS)\u306e\u4f7f\u3044\u65b9\u5b8c\u5168\u30ac\u30a4\u30c9\uff5c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089SQL\u5b9f\u884c\u307e\u3067\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac"},"content":{"rendered":"\n<style>\n.g-flow-row{display:flex;gap:8px;justify-content:center;flex-wrap:wrap;align-items:center;}\n.g-flow-item{background:linear-gradient(135deg,#1a1a1a,#2a1015);color:#fff;border-radius:8px;padding:16px 14px;min-width:130px;flex:1;text-align:center;}\n.g-flow-arrow{color:#dc2626;font-size:20px;font-weight:700;}\n.g-card-row{display:flex;gap:12px;flex-wrap:wrap;margin:0 0 32px;}\n.g-card-row>div{flex:1;min-width:220px;}\n@media(max-width:600px){\n  .g-flow-row{flex-direction:column;}\n  .g-flow-arrow{transform:rotate(90deg);}\n  .g-card-row{flex-direction:column;}\n  .g-card-row>div{min-width:100%;}\n}\n<\/style>\n\n\n\n<div style=\"background:#f8f9fa;border-radius:12px;padding:24px 28px;margin:0 0 32px;border-left:4px solid #dc2626;\">\n  <p style=\"font-size:15px;font-weight:700;color:#1a1a1a;margin:0 0 16px;\">\u3053\u306e\u8a18\u4e8b\u306e\u5185\u5bb9<\/p>\n  <ol style=\"margin:0;padding-left:20px;font-size:14px;line-height:2.2;list-style:none;\">\n    <li><a href=\"#sec-01\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">01<\/span>SQL Server\u3068SSMS\u306e\u57fa\u790e\u77e5\u8b58<\/a><\/li>\n    <li><a href=\"#sec-02\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">02<\/span>SSMS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5<\/a><\/li>\n    <li><a href=\"#sec-03\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">03<\/span>SSMS\u3078\u306e\u30ed\u30b0\u30a4\u30f3\u3068\u521d\u671f\u8a2d\u5b9a<\/a><\/li>\n    <li><a href=\"#sec-04\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">04<\/span>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u65b9\u6cd5<\/a><\/li>\n    <li><a href=\"#sec-05\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">05<\/span>\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u3068\u30c7\u30fc\u30bf\u578b<\/a><\/li>\n    <li><a href=\"#sec-06\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">06<\/span>INSERT\u30fbSELECT\u30fbUPDATE\u30fbDELETE\u6587<\/a><\/li>\n    <li><a href=\"#sec-07\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">07<\/span>WHERE\u53e5\u3068\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/a><\/li>\n    <li><a href=\"#sec-08\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">08<\/span>JOIN\u306b\u3088\u308b\u30c6\u30fc\u30d6\u30eb\u7d50\u5408<\/a><\/li>\n    <li><a href=\"#sec-09\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">09<\/span>\u30af\u30a8\u30ea\u81ea\u52d5\u4f5c\u6210\u6a5f\u80fd\u306e\u4f7f\u3044\u65b9<\/a><\/li>\n    <li><a href=\"#faq\" style=\"color:#495057;text-decoration:none;\"><span style=\"color:#dc2626;font-weight:700;margin-right:8px;\">FAQ<\/span>\u3088\u304f\u3042\u308b\u8cea\u554f<\/a><\/li>\n  <\/ol>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cSQL\u3063\u3066\u96e3\u3057\u305d\u3046\u2026\u300d\u300cSSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3051\u3069\u4f55\u304b\u3089\u3084\u308c\u3070\u3044\u3044\u304b\u5206\u304b\u3089\u306a\u3044\u300d\u2014\u2014\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u521d\u3081\u3066\u89e6\u308b\u65b9\u306e\u307b\u3068\u3093\u3069\u304c\u3001\u3053\u306e\u58c1\u306b\u3076\u3064\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Server Management Studio\uff08SSMS\uff09\u306f\u3001Microsoft\u304c\u7121\u511f\u3067\u63d0\u4f9b\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30c4\u30fc\u30eb\u3067\u3059\u3002<strong>SQL\u306e\u5b9f\u884c\u30fb\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u30fb\u30c7\u30fc\u30bf\u306e\u53c2\u7167\u30fb\u30af\u30a8\u30ea\u306e\u81ea\u52d5\u751f\u6210<\/strong>\u306a\u3069\u3001SQL Server\u3092\u6271\u3046\u3059\u3079\u3066\u306e\u4f5c\u696d\u3092GUI\u3067\u76f4\u611f\u7684\u306b\u64cd\u4f5c\u3067\u304d\u307e\u3059\u3002\u30a8\u30f3\u30b8\u30cb\u30a2\u3060\u3051\u3067\u306a\u304f\u3001\u696d\u52d9\u30b7\u30b9\u30c6\u30e0\u306e\u7ba1\u7406\u8005\u3084\u30c7\u30fc\u30bf\u5206\u6790\u62c5\u5f53\u8005\u306b\u3068\u3063\u3066\u3082\u6b20\u304b\u305b\u306a\u3044\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001SSMS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089\u59cb\u3081\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u3001SELECT\u30fbINSERT\u30fbUPDATE\u30fbDELETE\u6587\u306e\u5b9f\u884c\u3001\u30af\u30a8\u30ea\u306e\u81ea\u52d5\u751f\u6210\u6a5f\u80fd\u307e\u3067\u3001<strong>\u521d\u5fc3\u8005\u304c\u5b9f\u969b\u306b\u624b\u3092\u52d5\u304b\u3057\u306a\u304c\u3089\u5b66\u3079\u308b\u3088\u3046<\/strong>\u3001\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306e\u4ee3\u308f\u308a\u306b\u4e01\u5be7\u306a\u30b9\u30c6\u30c3\u30d7\u3067\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"balloon-wrap\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/ceo-sugasawa.jpg\" alt=\"\u4ee3\u8868\u83c5\u6fa4\">\n    <span class=\"balloon-name\">\u4ee3\u8868\u83c5\u6fa4<\/span>\n  <\/div>\n  <div class=\"balloon-body\">\u5f0a\u793e\uff08\u682a\u5f0f\u4f1a\u793eGENAI\uff09\u3067\u306f\u3001\u696d\u52d9\u30b7\u30b9\u30c6\u30e0\u3068\u306e\u30c7\u30fc\u30bf\u9023\u643a\u306bSQL Server\u3092\u6d3b\u7528\u3057\u3066\u3044\u307e\u3059\u3002SSMS\u3092\u4f7f\u3044\u3053\u306a\u305b\u308b\u3068\u3001\u696d\u52d9\u30c7\u30fc\u30bf\u306e\u5206\u6790\u30fb\u62bd\u51fa\u30fb\u52a0\u5de5\u306e\u81ea\u7531\u5ea6\u304c\u683c\u6bb5\u306b\u4e0a\u304c\u308a\u307e\u3059\u3002\u4eca\u65e5\u306f\u305d\u306e\u5165\u9580\u3068\u3057\u3066\u3001\u6700\u521d\u306e\u4e00\u6b69\u3092\u8e0f\u307f\u51fa\u3057\u3066\u3082\u3089\u3048\u308c\u3070\u3068\u601d\u3044\u307e\u3059\u3002<\/div>\n<\/div>\n\n\n\n<div class=\"balloon-wrap is-right\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/yamazaki-avatar.png\" alt=\"AI\u9b3c\u7ba1\u7406\u5c71\u5d0e\">\n    <span class=\"balloon-name\">AI\u9b3c\u7ba1\u7406\u5c71\u5d0e<\/span>\n  <\/div>\n  <div class=\"balloon-body\">SQL\u306f\u300c\u96e3\u3057\u3044\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u300d\u3067\u306f\u306a\u304f\u3001<strong>\u300c\u65e5\u672c\u8a9e\u3067\u8a00\u3044\u305f\u3044\u3053\u3068\u3092\u30b7\u30f3\u30d7\u30eb\u306a\u82f1\u8a9e\u306b\u5909\u63db\u3057\u305f\u3082\u306e\u300d<\/strong>\u3067\u3059\u3002\u300c\u9867\u5ba2\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u6771\u4eac\u306e\u9867\u5ba2\u3092\u53d6\u5f97\u3057\u3066\u300d\u2192 SELECT * FROM customers WHERE city = '\u6771\u4eac' \u2014 \u3053\u306e\u5bfe\u5fdc\u95a2\u4fc2\u3055\u3048\u63b4\u3081\u3070\u3001\u3042\u3068\u306f\u5fdc\u7528\u3067\u3059\u3002<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u8a18\u4e8b\u3092\u8aad\u307f\u7d42\u3048\u308b\u3068\u3001\u6b21\u306e\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"background:#fafafa;border-radius:8px;padding:16px 20px;margin:16px 0;border-left:4px solid #dc2626;\">\n<div style=\"display:flex;align-items:flex-start;gap:8px;padding:6px 0;font-size:15px;line-height:1.6;\"><span style=\"color:#dc2626;font-size:16px;flex-shrink:0;margin-top:2px;\">&#10004;&#65039;<\/span><span><strong>SSMS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068\u521d\u671f\u8a2d\u5b9a<\/strong>\uff1a\u516c\u5f0f\u30b5\u30a4\u30c8\u304b\u3089\u306e\u624b\u9806\u3092\u56f3\u89e3<\/span><\/div>\n<div style=\"display:flex;align-items:flex-start;gap:8px;padding:6px 0;font-size:15px;line-height:1.6;\"><span style=\"color:#dc2626;font-size:16px;flex-shrink:0;margin-top:2px;\">&#10004;&#65039;<\/span><span><strong>SQL Server\u3078\u306e\u63a5\u7d9a<\/strong>\uff1a\u30ed\u30fc\u30ab\u30eb\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u30ed\u30b0\u30a4\u30f3\u65b9\u6cd5<\/span><\/div>\n<div style=\"display:flex;align-items:flex-start;gap:8px;padding:6px 0;font-size:15px;line-height:1.6;\"><span style=\"color:#dc2626;font-size:16px;flex-shrink:0;margin-top:2px;\">&#10004;&#65039;<\/span><span><strong>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30fb\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210<\/strong>\uff1aGUI\u3068SQL\u306e\u4e21\u65b9\u3067\u5b9f\u884c<\/span><\/div>\n<div style=\"display:flex;align-items:flex-start;gap:8px;padding:6px 0;font-size:15px;line-height:1.6;\"><span style=\"color:#dc2626;font-size:16px;flex-shrink:0;margin-top:2px;\">&#10004;&#65039;<\/span><span><strong>\u57fa\u672cSQL4\u7a2e<\/strong>\uff1aSELECT\u30fbINSERT\u30fbUPDATE\u30fbDELETE\u306e\u66f8\u304d\u65b9\u3068\u5b9f\u884c<\/span><\/div>\n<div style=\"display:flex;align-items:flex-start;gap:8px;padding:6px 0;font-size:15px;line-height:1.6;\"><span style=\"color:#dc2626;font-size:16px;flex-shrink:0;margin-top:2px;\">&#10004;&#65039;<\/span><span><strong>WHERE\u53e5\u30fbJOIN<\/strong>\uff1a\u30c7\u30fc\u30bf\u3092\u7d5e\u308a\u8fbc\u3080\u30fb\u8907\u6570\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3059\u308b<\/span><\/div>\n<div style=\"display:flex;align-items:flex-start;gap:8px;padding:6px 0;font-size:15px;line-height:1.6;\"><span style=\"color:#dc2626;font-size:16px;flex-shrink:0;margin-top:2px;\">&#10004;&#65039;<\/span><span><strong>\u30af\u30a8\u30ea\u81ea\u52d5\u4f5c\u6210\u6a5f\u80fd<\/strong>\uff1aGUI\u304b\u3089SQL\u3092\u81ea\u52d5\u751f\u6210\u3059\u308b\u88cf\u6280<\/span><\/div>\n\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-01\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">01<\/span>\n  <span class=\"section-label\" style=\"display:block;\">BASICS<\/span>\n  <span class=\"section-title\" style=\"display:block;\">SQL Server\u3068SSMS\u306e\u57fa\u790e\u77e5\u8b58<\/span>\n  <span class=\"section-desc\">\u307e\u305a\u300c\u4f55\u304c\u3069\u3046\u3044\u3046\u95a2\u4fc2\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u300d\u3092\u6574\u7406\u3059\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u969b\u306b\u624b\u3092\u52d5\u304b\u3059\u524d\u306b\u3001SQL Server\u3068SSMS\u306e\u95a2\u4fc2\u3092\u6574\u7406\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002\u3053\u308c\u3092\u7406\u89e3\u3057\u3066\u304a\u304f\u3068\u3001\u5f8c\u306e\u64cd\u4f5c\u306e\u610f\u5473\u304c\u306f\u3063\u304d\u308a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1-1. SQL Server\u3068\u306f<\/h3>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>SQL Server\uff08Microsoft SQL Server\uff09<\/strong>\uff1aMicrosoft\u304c\u958b\u767a\u30fb\u63d0\u4f9b\u3059\u308b\u4f01\u696d\u5411\u3051\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\uff08RDBMS\uff09\u3002Windows\u74b0\u5883\u3068\u306e\u89aa\u548c\u6027\u304c\u9ad8\u304f\u3001\u4e2d\u5805\u301c\u5927\u4f01\u696d\u306e\u57fa\u5e79\u30b7\u30b9\u30c6\u30e0\u3084\u696d\u52d9\u30b7\u30b9\u30c6\u30e0\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u3057\u3066\u5e83\u304f\u63a1\u7528\u3055\u308c\u3066\u3044\u308b\u3002\u7121\u511f\u7248\u306eSQL Server Express\u304b\u3089\u3001\u5927\u898f\u6a21\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba\u5411\u3051\u306eEnterprise\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u307e\u3067\u3001\u7528\u9014\u306b\u5fdc\u3058\u305f\u8907\u6570\u306e\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u304c\u3042\u308b\u3002<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Server\u306f\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\u30fb\u7ba1\u7406\u3059\u308b\u300c\u30a8\u30f3\u30b8\u30f3\uff08\u6a5f\u95a2\u90e8\uff09\u300d\u3067\u3059\u3002\u5009\u5eab\u306b\u4f8b\u3048\u308b\u3068\u3001<strong>\u300c\u5b9f\u969b\u306b\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3057\u3066\u3044\u308b\u5009\u5eab\u305d\u306e\u3082\u306e\u300d<\/strong>\u304cSQL Server\u3067\u3059\u3002SQL Server\u306f\u5e38\u306b\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u3067\u7a3c\u50cd\u3057\u3066\u304a\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089\u306e\u30c7\u30fc\u30bf\u8981\u6c42\u306b\u5fdc\u3048\u7d9a\u3051\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1-2. SSMS\u3068\u306f<\/h3>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>SSMS\uff08SQL Server Management Studio\uff09<\/strong>\uff1aMicrosoft\u304cSQL Server\u7ba1\u7406\u7528\u306b\u7121\u511f\u63d0\u4f9b\u3059\u308bGUI\u30c4\u30fc\u30eb\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u30fb\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u30fbSQL\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u30fb\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30fb\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u76e3\u8996\u307e\u3067\u3001SQL Server\u306b\u95a2\u3059\u308b\u307b\u307c\u5168\u3066\u306e\u7ba1\u7406\u4f5c\u696d\u3092\u30b0\u30e9\u30d5\u30a3\u30ab\u30eb\u306b\u884c\u3048\u308b\u3002SQL Server\u3068\u306f\u5225\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3068\u3057\u3066\u63d0\u4f9b\u3055\u308c\u3001\u72ec\u81ea\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304c\u5fc5\u8981\u3002<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">SSMS\u306f\u5009\u5eab\u306b\u4f8b\u3048\u308b\u3068<strong>\u300c\u5009\u5eab\u306e\u64cd\u4f5c\u30d1\u30cd\u30eb\u30fb\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u300d<\/strong>\u3067\u3059\u3002SQL Server\uff08\u5009\u5eab\uff09\u306b\u6307\u793a\u3092\u51fa\u3057\u305f\u308a\u3001\u4e2d\u8eab\u3092\u8997\u3044\u305f\u308a\u3001\u30c7\u30fc\u30bf\u3092\u6574\u7406\u3057\u305f\u308a\u3059\u308b\u305f\u3081\u306e\u64cd\u4f5c\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067\u3059\u3002SSMS\u304c\u306a\u304f\u3066\u3082SQL Server\u306f\u52d5\u304d\u307e\u3059\u304c\u3001SSMS\u304c\u3042\u308b\u3053\u3068\u3067\u4eba\u9593\u304c\u76f4\u611f\u7684\u306b\u7ba1\u7406\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>RDBMS\uff08\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\uff09<\/strong>\uff1a\u30c7\u30fc\u30bf\u3092\u884c\u3068\u5217\u3067\u69cb\u6210\u3055\u308c\u305f\u300c\u8868\uff08\u30c6\u30fc\u30d6\u30eb\uff09\u300d\u306e\u5f62\u5f0f\u3067\u7ba1\u7406\u3057\u3001\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u9593\u306e\u95a2\u4fc2\uff08\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\uff09\u3092\u5b9a\u7fa9\u30fb\u7ba1\u7406\u3067\u304d\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u306e\u7dcf\u79f0\u3002SQL Server\u3001MySQL\u3001PostgreSQL\u3001Oracle\u306a\u3069\u304c\u4ee3\u8868\u7684\u306aRDBMS\u3002SQL\u3068\u3044\u3046\u5171\u901a\u8a00\u8a9e\u3067\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3067\u304d\u308b\u70b9\u304c\u7279\u5fb4\u3002<\/p>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">1-3. SQL Server\u3068SSMS\u306e\u95a2\u4fc2<\/h3>\n\n\n\n<table>\n<thead><tr><th>\u9805\u76ee<\/th><th>SQL Server<\/th><th>SSMS<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\u5f79\u5272<\/td><td>\u30c7\u30fc\u30bf\u306e\u4fdd\u5b58\u30fb\u7ba1\u7406\u30a8\u30f3\u30b8\u30f3<\/td><td>SQL Server\u3092\u64cd\u4f5c\u3059\u308bGUI\u30c4\u30fc\u30eb<\/td><\/tr>\n<tr><td>\u63d0\u4f9b\u5f62\u614b<\/td><td>\u30b5\u30fc\u30d3\u30b9\uff08\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u3067\u5e38\u6642\u8d77\u52d5\uff09<\/td><td>\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/td><\/tr>\n<tr><td>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/td><td>\u5225\u9014\u5fc5\u8981<\/td><td>\u5225\u9014\u5fc5\u8981\uff08\u7121\u511f\uff09<\/td><\/tr>\n<tr><td>\u306a\u304f\u3066\u3082\u52d5\u304f\u304b<\/td><td>\u2014\uff08\u30b3\u30a2\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\uff09<\/td><td>\u306f\u3044\uff08\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067\u4ee3\u66ff\u53ef\u80fd\uff09<\/td><\/tr>\n<tr><td>\u7121\u511f\u7248<\/td><td>SQL Server Express \/ Developer<\/td><td>SSMS\u672c\u4f53\u306f\u5e38\u306b\u7121\u511f<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n\n<p class=\"wp-block-paragraph\">\u91cd\u8981\u306a\u306e\u306f\u300c<strong>SQL Server\u3068SSMS\u306f\u5225\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2<\/strong>\u300d\u3068\u3044\u3046\u70b9\u3067\u3059\u3002SQL Server\u304c\u306a\u3051\u308c\u3070SSMS\u3092\u8d77\u52d5\u3057\u3066\u3082\u63a5\u7d9a\u5148\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u307e\u305aSQL Server\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304b\u3089\u3001SSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u63a5\u7d9a\u3059\u308b\u3001\u3068\u3044\u3046\u9806\u5e8f\u3067\u9032\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"balloon-wrap is-right\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/yamazaki-avatar.png\" alt=\"AI\u9b3c\u7ba1\u7406\u5c71\u5d0e\">\n    <span class=\"balloon-name\">AI\u9b3c\u7ba1\u7406\u5c71\u5d0e<\/span>\n  <\/div>\n  <div class=\"balloon-body\">\u300cSQL Server\u3092\u8cb7\u308f\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u306e\u3067\u306f\uff1f\u300d\u3068\u5fc3\u914d\u3055\u308c\u308b\u65b9\u304c\u591a\u3044\u3067\u3059\u304c\u3001\u5b66\u7fd2\u30fb\u958b\u767a\u7528\u9014\u306a\u3089<strong>SQL Server Developer Edition<\/strong>\uff08\u672c\u756a\u5229\u7528\u4ee5\u5916\u306f\u7121\u511f\uff09\u307e\u305f\u306fSQL Server Express\u3067\u5341\u5206\u3067\u3059\u3002\u3053\u306e\u8a18\u4e8b\u306e\u624b\u9806\u306fDeveloper Edition\u3092\u524d\u63d0\u306b\u8aac\u660e\u3057\u307e\u3059\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-02\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">02<\/span>\n  <span class=\"section-label\" style=\"display:block;\">INSTALL<\/span>\n  <span class=\"section-title\" style=\"display:block;\">SSMS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5<\/span>\n  <span class=\"section-desc\">SQL Server\u3068SSMS\u3092\u9806\u756a\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u300cSQL Server\u672c\u4f53 \u2192 SSMS\u300d\u306e\u9806\u3067\u9032\u3081\u307e\u3059\u3002\u3069\u3061\u3089\u3082Microsoft\u306e\u516c\u5f0f\u30b5\u30a4\u30c8\u304b\u3089\u7121\u511f\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2-1. \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u5168\u4f53\u30d5\u30ed\u30fc<\/h3>\n\n\n\n<div class=\"g-flow-row\" style=\"margin:24px 0;\">\n  <div class=\"g-flow-item\"><strong>Step 1<\/strong><br><span style=\"font-size:12px;\">SQL Server<br>Developer\u7248<br>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/span><\/div>\n  <div class=\"g-flow-arrow\">&#8594;<\/div>\n  <div class=\"g-flow-item\"><strong>Step 2<\/strong><br><span style=\"font-size:12px;\">SQL Server<br>\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc<br>\u5b9f\u884c\u30fb\u5b8c\u4e86<\/span><\/div>\n  <div class=\"g-flow-arrow\">&#8594;<\/div>\n  <div class=\"g-flow-item\"><strong>Step 3<\/strong><br><span style=\"font-size:12px;\">SSMS\u3092<br>\u516c\u5f0f\u30b5\u30a4\u30c8\u304b\u3089<br>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/span><\/div>\n  <div class=\"g-flow-arrow\">&#8594;<\/div>\n  <div class=\"g-flow-item\"><strong>Step 4<\/strong><br><span style=\"font-size:12px;\">SSMS\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc<br>\u5b9f\u884c\u30fb\u518d\u8d77\u52d5<\/span><\/div>\n  <div class=\"g-flow-arrow\">&#8594;<\/div>\n  <div class=\"g-flow-item\"><strong>Step 5<\/strong><br><span style=\"font-size:12px;\">SSMS\u3092\u8d77\u52d5\u3057\u3066<br>SQL Server\u306b<br>\u63a5\u7d9a\u78ba\u8a8d<\/span><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2-2. SQL Server\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u624b\u9806<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u2460 Microsoft\u306e\u516c\u5f0f\u30da\u30fc\u30b8\uff08microsoft.com\/ja-jp\/sql-server\/sql-server-downloads\uff09\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2461 \u300cDeveloper\u300d\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u306e\u300c\u4eca\u3059\u3050\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002Developer\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u306f\u3059\u3079\u3066\u306e\u6a5f\u80fd\u304c\u4f7f\u3048\u307e\u3059\u304c\u3001<strong>\u672c\u756a\u74b0\u5883\u3067\u306e\u5229\u7528\u306f\u30e9\u30a4\u30bb\u30f3\u30b9\u4e0a\u4e0d\u53ef<\/strong>\u3067\u3059\u3002\u672c\u756a\u5229\u7528\u306fExpress\u307e\u305f\u306f\u6709\u511f\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u3092\u9078\u3093\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2462 \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u300cSQL2022-SSEI-Dev.exe\u300d\uff08\u30d5\u30a1\u30a4\u30eb\u540d\u306f\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u308a\u5909\u5316\uff09\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2463 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u7a2e\u985e\u9078\u629e\u753b\u9762\u3067\u300c\u57fa\u672c\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\u521d\u3081\u3066\u306e\u65b9\u306f\u30ab\u30b9\u30bf\u30e0\u3084\u8a73\u7d30\u8a2d\u5b9a\u306f\u4e0d\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2464 \u30e9\u30a4\u30bb\u30f3\u30b9\u6761\u9805\u306b\u540c\u610f\u3057\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u3092\u78ba\u8a8d\u3057\u3066\u300c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u306f\u901a\u5e385\u301c15\u5206\u304b\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2465 \u300c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u30e1\u30e2\u5e33\u306b\u300c\u63a5\u7d9a\u6587\u5b57\u5217\u300d\u306e\u30c6\u30ad\u30b9\u30c8\u3092\u30b3\u30d4\u30fc\u3057\u3066\u4fdd\u5b58\u3057\u3066\u304a\u304d\u307e\u3059\uff08\u5f8c\u306eSSMS\u63a5\u7d9a\u3067\u4f7f\u3044\u307e\u3059\uff09\u3002<\/p>\n\n\n\n<div style=\"background:#f0fdf4;border:1px solid #22c55e;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:18px;\">&#128161;<\/span>\n    <strong style=\"color:#16a34a;font-size:15px;\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5b8c\u4e86\u5f8c\u306e\u30e1\u30e2\u63a8\u5968\u4e8b\u9805<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">SQL Server\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5b8c\u4e86\u753b\u9762\u306b\u300c\u63a5\u7d9a\u6587\u5b57\u5217\u300d\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u308b\u300cServer=localhost\\SQLEXPRESS;...\u300d\u306e\u3088\u3046\u306a\u6587\u5b57\u5217\u306f\u3001\u5fc5\u305a\u30e1\u30e2\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002SSMS\u304b\u3089\u306e\u63a5\u7d9a\u6642\u306b\u3053\u306e\u30b5\u30fc\u30d0\u30fc\u540d\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002\u30b3\u30d4\u30fc\u3057\u5fd8\u308c\u305f\u5834\u5408\u306f\u300cSQL Server 2022 \u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u300d\u304b\u3089\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2-3. SSMS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u624b\u9806<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u2460 Microsoft\u306e\u516c\u5f0f\u30da\u30fc\u30b8\uff08learn.microsoft.com\/ja-jp\/ssms\/download-sql-server-management-studio-ssms\uff09\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2461 \u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u306eSSMS\uff08\u4f8b\uff1aSSMS 20.x\uff09\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30ea\u30f3\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30d5\u30a1\u30a4\u30eb\u540d\u306f\u300cSSMS-Setup-JPN.exe\u300d\u306e\u3088\u3046\u306a\u5f62\u5f0f\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2462 \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u307e\u307e\u3067\u69cb\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2463 \u300c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u5b8c\u4e86\u307e\u3067\u5f85\u3061\u307e\u3059\uff085\u301c10\u5206\u7a0b\u5ea6\uff09\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2464 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5b8c\u4e86\u5f8c\u3001\u300c\u518d\u8d77\u52d5\u300d\u3092\u6c42\u3081\u3089\u308c\u305f\u3089\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2465 \u30b9\u30bf\u30fc\u30c8\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300cMicrosoft SQL Server Management Studio\u300d\u3092\u691c\u7d22\u3057\u3066\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"balloon-wrap\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/ceo-sugasawa.jpg\" alt=\"\u4ee3\u8868\u83c5\u6fa4\">\n    <span class=\"balloon-name\">\u4ee3\u8868\u83c5\u6fa4<\/span>\n  <\/div>\n  <div class=\"balloon-body\">SQL Server\u3068SSMS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u3001\u521d\u3081\u3066\u3060\u3068\u300c\u3069\u308c\u304c\u5fc5\u8981\u304b\u300d\u304c\u5206\u304b\u308a\u306b\u304f\u3044\u8a2d\u8a08\u3067\u3059\u3002\u8ff7\u3063\u305f\u3089SQL Server Developer + SSMS\u306e\u6700\u65b0\u7248\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u3057\u3066\u304a\u3051\u3070\u9593\u9055\u3044\u3042\u308a\u307e\u305b\u3093\u3002\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u539f\u5247\u3068\u3057\u3066\u6700\u65b0\u7248\u3092\u9078\u3093\u3067\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"background:#fef2f2;border:2px solid #dc2626;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:20px;\">&#9888;&#65039;<\/span>\n    <strong style=\"color:#dc2626;font-size:16px;\">Windows\u5c02\u7528\u30c4\u30fc\u30eb<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">SSMS\u306fWindows\u5c02\u7528\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3067\u3059\u3002macOS\u3084Linux\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002macOS\u3067SQL Server\u3092\u7ba1\u7406\u3057\u305f\u3044\u5834\u5408\u306f\u3001Azure Data Studio\uff08Microsoft\u306e\u4ee3\u66ff\u30c4\u30fc\u30eb\u3001macOS\u5bfe\u5fdc\uff09\u3092\u4f7f\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-03\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">03<\/span>\n  <span class=\"section-label\" style=\"display:block;\">LOGIN & SETUP<\/span>\n  <span class=\"section-title\" style=\"display:block;\">SSMS\u3078\u306e\u30ed\u30b0\u30a4\u30f3\u3068\u521d\u671f\u8a2d\u5b9a<\/span>\n  <span class=\"section-desc\">SSMS\u3092\u8d77\u52d5\u3057\u3066SQL Server\u306b\u63a5\u7d9a\u3059\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SSMS\u3092\u8d77\u52d5\u3059\u308b\u3068\u6700\u521d\u306b\u300c\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u3053\u3067SQL Server\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3-1. \u63a5\u7d9a\u30c0\u30a4\u30a2\u30ed\u30b0\u306e\u5404\u9805\u76ee<\/h3>\n\n\n\n<table>\n<thead><tr><th>\u9805\u76ee<\/th><th>\u8a2d\u5b9a\u5024\uff08\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u306e\u5834\u5408\uff09<\/th><th>\u8aac\u660e<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\u30b5\u30fc\u30d0\u30fc\u306e\u7a2e\u985e<\/td><td>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30a8\u30f3\u30b8\u30f3<\/td><td>\u901a\u5e38\u306f\u3053\u306e\u307e\u307e\u5909\u66f4\u4e0d\u8981<\/td><\/tr>\n<tr><td>\u30b5\u30fc\u30d0\u30fc\u540d<\/td><td>localhost \u307e\u305f\u306f . \u307e\u305f\u306f \u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u540d\\SQLEXPRESS<\/td><td>SQL Server\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3002Express\u306f\\SQLEXPRESS\u3092\u4ed8\u3051\u308b<\/td><\/tr>\n<tr><td>\u8a8d\u8a3c<\/td><td>Windows \u8a8d\u8a3c<\/td><td>\u521d\u671f\u8a2d\u5b9a\u306fWindows\u8a8d\u8a3c\u304c\u6700\u3082\u7c21\u5358<\/td><\/tr>\n<tr><td>\u30e6\u30fc\u30b6\u30fc\u540d<\/td><td>\uff08\u81ea\u52d5\u5165\u529b\uff09<\/td><td>Windows\u8a8d\u8a3c\u306e\u5834\u5408\u306f\u73fe\u5728\u306eWindows\u30e6\u30fc\u30b6\u30fc\u540d\u304c\u81ea\u52d5\u5165\u529b<\/td><\/tr>\n<tr><td>\u30d1\u30b9\u30ef\u30fc\u30c9<\/td><td>\uff08\u4e0d\u8981\uff09<\/td><td>Windows\u8a8d\u8a3c\u3067\u306f\u4e0d\u8981<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n\n<p class=\"wp-block-paragraph\">\u30ed\u30fc\u30ab\u30eb\u306bSQL Server\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u5834\u5408\u3001\u30b5\u30fc\u30d0\u30fc\u540d\u306f\u901a\u5e38\u300c<strong>localhost<\/strong>\u300d\u307e\u305f\u306f\u300c<strong>.<\/strong>\uff08\u30c9\u30c3\u30c8\u4e00\u3064\uff09\u300d\u3067\u63a5\u7d9a\u3067\u304d\u307e\u3059\u3002SQL Server Express\u306e\u5834\u5408\u306f\u300c<strong>localhost\\SQLEXPRESS<\/strong>\u300d\u306e\u3088\u3046\u306b\u540d\u524d\u4ed8\u304d\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u306a\u308b\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u63a5\u7d9a\u6587\u5b57\u5217\u306e\u4f8b\uff08\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089SQL Server\u306b\u63a5\u7d9a\u3059\u308b\u969b\u306e\u53c2\u8003\uff09\n-- SQL Server Express \u30ed\u30fc\u30ab\u30eb\u63a5\u7d9a\nServer=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;\n\n-- SQL Server Developer \u30ed\u30fc\u30ab\u30eb\u63a5\u7d9a\nServer=localhost;Database=master;Trusted_Connection=True;\n\n-- SQL Server\u8a8d\u8a3c\uff08sa\u7b49\u306eSQL\u30e6\u30fc\u30b6\u30fc\uff09\nServer=192.168.1.10;Database=SampleDB;User Id=sa;Password=YourPassword;<\/code><\/pre>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>\u30af\u30a8\u30ea\uff08Query\uff09<\/strong>\uff1a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u300c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u300d\u300c\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b\u300d\u300c\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3059\u308b\u300d\u300c\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b\u300d\u306a\u3069\u306e\u6307\u793a\u3092\u51fa\u3059SQL\u6587\u306e\u3053\u3068\u3002\u82f1\u8a9e\u3067\u300c\u554f\u3044\u5408\u308f\u305b\u300d\u3092\u610f\u5473\u3059\u308b\u5358\u8a9e\u304c\u8a9e\u6e90\u3002SELECT\u6587\u30fbINSERT\u6587\u30fbUPDATE\u6587\u30fbDELETE\u6587\u306a\u3069\u304c\u3059\u3079\u3066\u30af\u30a8\u30ea\u306b\u542b\u307e\u308c\u308b\u3002<\/p>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3-2. \u63a5\u7d9a\u5f8c\u306eSSMS\u306e\u753b\u9762\u69cb\u6210<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u63a5\u7d9a\u306b\u6210\u529f\u3059\u308b\u3068\u3001SSMS\u306e\u30e1\u30a4\u30f3\u753b\u9762\u304c\u958b\u304d\u307e\u3059\u3002\u4e3b\u8981\u306a\u30d1\u30cd\u30eb\u306e\u5f79\u5272\u3092\u899a\u3048\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<table>\n<thead><tr><th>\u30d1\u30cd\u30eb\u540d<\/th><th>\u5834\u6240<\/th><th>\u4e3b\u306a\u7528\u9014<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8 \u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc<\/td><td>\u5de6\u5074<\/td><td>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u30fb\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u306e\u30c4\u30ea\u30fc\u8868\u793a<\/td><\/tr>\n<tr><td>\u30af\u30a8\u30ea \u30a8\u30c7\u30a3\u30bf\u30fc<\/td><td>\u4e2d\u592e<\/td><td>SQL\u3092\u76f4\u63a5\u5165\u529b\u3057\u3066\u5b9f\u884c\u3059\u308b\u30a8\u30ea\u30a2<\/td><\/tr>\n<tr><td>\u7d50\u679c\u30b0\u30ea\u30c3\u30c9<\/td><td>\u4e0b\u90e8<\/td><td>SELECT\u306e\u5b9f\u884c\u7d50\u679c\u3092\u30c6\u30fc\u30d6\u30eb\u5f62\u5f0f\u3067\u8868\u793a<\/td><\/tr>\n<tr><td>\u30e1\u30c3\u30bb\u30fc\u30b8<\/td><td>\u4e0b\u90e8\uff08\u30bf\u30d6\uff09<\/td><td>INSERT\/UPDATE\/DELETE\u306e\u5b9f\u884c\u4ef6\u6570\u30fb\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8<\/td><\/tr>\n<tr><td>\u30d7\u30ed\u30d1\u30c6\u30a3<\/td><td>\u53f3\u5074<\/td><td>\u9078\u629e\u3057\u305f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u8a73\u7d30\u60c5\u5831<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n\n<p class=\"wp-block-paragraph\">\u65b0\u3057\u3044\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf\u30fc\u306f\u3001\u30c4\u30fc\u30eb\u30d0\u30fc\u306e\u300c\u65b0\u3057\u3044\u30af\u30a8\u30ea\u300d\u30dc\u30bf\u30f3\u307e\u305f\u306f\u30ad\u30fc\u30dc\u30fc\u30c9\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8<strong>Ctrl + N<\/strong>\u3067\u958b\u3051\u307e\u3059\u3002\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u306f<strong>F5<\/strong>\u30ad\u30fc\u304c\u6700\u901f\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"background:#f0fdf4;border:1px solid #22c55e;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:18px;\">&#128161;<\/span>\n    <strong style=\"color:#16a34a;font-size:15px;\">SSMS\u306e\u4fbf\u5229\u306a\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">\u3088\u304f\u4f7f\u3046\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8: F5 = \u30af\u30a8\u30ea\u5b9f\u884c \/ Ctrl+N = \u65b0\u898f\u30af\u30a8\u30ea \/ Ctrl+K+C = \u9078\u629e\u884c\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8 \/ Ctrl+K+U = \u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u89e3\u9664 \/ Ctrl+R = \u7d50\u679c\u30da\u30a4\u30f3\u306e\u8868\u793a\/\u975e\u8868\u793a\u5207\u66ff \/ Alt+F1 = \u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u306e\u78ba\u8a8d\uff08sp_help\u3092\u5b9f\u884c\uff09<\/p>\n<\/div>\n\n\n\n<div class=\"balloon-wrap is-right\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/yamazaki-avatar.png\" alt=\"AI\u9b3c\u7ba1\u7406\u5c71\u5d0e\">\n    <span class=\"balloon-name\">AI\u9b3c\u7ba1\u7406\u5c71\u5d0e<\/span>\n  <\/div>\n  <div class=\"balloon-body\">\u63a5\u7d9a\u304c\u300c\u5931\u6557\u300d\u3057\u3066\u3082\u614c\u3066\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\u6700\u3082\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u306f\u300c\u30b5\u30fc\u30d0\u30fc\u540d\u306e\u9593\u9055\u3044\u300d\u3067\u3059\u3002\u300clocalhost\u300d\u3067\u7e4b\u304c\u3089\u306a\u3044\u5834\u5408\u306f\u300c.\u300d\uff08\u30c9\u30c3\u30c8\uff09\u3001\u305d\u308c\u3067\u3082\u7e4b\u304c\u3089\u306a\u3044\u5834\u5408\u306f\u300c\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u540d\\SQLEXPRESS\u3067\u306e\u63a5\u7d9a\u3092\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-04\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">04<\/span>\n  <span class=\"section-label\" style=\"display:block;\">CREATE DATABASE<\/span>\n  <span class=\"section-title\" style=\"display:block;\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u65b9\u6cd5<\/span>\n  <span class=\"section-desc\">GUI\u3068SQL\u30b3\u30de\u30f3\u30c9\u306e\u4e21\u65b9\u3067\u4f5c\u6210\u3059\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL Server\u306b\u63a5\u7d9a\u3067\u304d\u305f\u3089\u3001\u6b21\u306f\u5b9f\u969b\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002SSMS\u306b\u306f<strong>GUI\u304b\u3089\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/strong>\u3068<strong>SQL\u3092\u66f8\u3044\u3066\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/strong>\u306e2\u901a\u308a\u304c\u3042\u308a\u307e\u3059\u3002\u3069\u3061\u3089\u3082\u899a\u3048\u3066\u304a\u304f\u3068\u5b9f\u7528\u7684\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4-1. GUI\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u2460 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u306e\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300d\u30d5\u30a9\u30eb\u30c0\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2461 \u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2462 \u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u958b\u304d\u307e\u3059\u3002\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u300d\u6b04\u306b\u4efb\u610f\u306e\u540d\u524d\uff08\u4f8b\uff1aSampleDB\uff09\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2463 \u30aa\u30fc\u30ca\u30fc\u306f\u300c&lt;\u65e2\u5b9a\u5024&gt;\u300d\u306e\u307e\u307e\u3067OK\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2464 \u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u306b\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4-2. SQL\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210\u306f\u3001CREATE DATABASE\u6587\u3092\u4f7f\u3044\u307e\u3059\u3002\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u4ee5\u4e0b\u3092\u5165\u529b\u3057\u3066F5\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\nCREATE DATABASE SampleDB;\n\n-- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u4f5c\u6210\u3055\u308c\u305f\u304b\u78ba\u8a8d\nSELECT name, database_id, create_date\nFROM sys.databases\nWHERE name = 'SampleDB';\n\n-- \u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5207\u308a\u66ff\u3048\nUSE SampleDB;\nGO<\/code><\/pre>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>DDL\uff08\u30c7\u30fc\u30bf\u5b9a\u7fa9\u8a00\u8a9e\uff09<\/strong>\uff1aData Definition Language\u306e\u7565\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3084\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u3092\u5b9a\u7fa9\u30fb\u5909\u66f4\u30fb\u524a\u9664\u3059\u308b\u305f\u3081\u306eSQL\u547d\u4ee4\u7fa4\u306e\u3053\u3068\u3002CREATE\uff08\u4f5c\u6210\uff09\u30fbALTER\uff08\u5909\u66f4\uff09\u30fbDROP\uff08\u524a\u9664\uff09\u30fbTRUNCATE\uff08\u30c7\u30fc\u30bf\u5168\u524a\u9664\uff09\u304c\u4ee3\u8868\u7684\u306aDDL\u547d\u4ee4\u3002\u30c7\u30fc\u30bf\u305d\u306e\u3082\u306e\u3067\u306f\u306a\u304f\u300c\u30c7\u30fc\u30bf\u3092\u5165\u308c\u308b\u5668\uff08\u69cb\u9020\uff09\u300d\u3092\u64cd\u4f5c\u3059\u308b\u70b9\u304cDML\u3068\u306e\u9055\u3044\u3002<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">CREATE DATABASE\u6587\u306f\u975e\u5e38\u306b\u30b7\u30f3\u30d7\u30eb\u3067\u3059\u304c\u3001\u5b9f\u52d9\u3067\u306f\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002\u4f8b\u3048\u3070<strong>\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148<\/strong>\u3084<strong>\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u7167\u5408\u9806\u5e8f<\/strong>\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3059\u308b\u30b1\u30fc\u30b9\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u8a73\u7d30\u30aa\u30d7\u30b7\u30e7\u30f3\u4ed8\u304d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210\u4f8b\nCREATE DATABASE SampleDB\nON PRIMARY (\n    NAME = 'SampleDB_Data',\n    FILENAME = 'C:\\SQLData\\SampleDB.mdf',\n    SIZE = 100MB,\n    MAXSIZE = 1GB,\n    FILEGROWTH = 10MB\n)\nLOG ON (\n    NAME = 'SampleDB_Log',\n    FILENAME = 'C:\\SQLData\\SampleDB.ldf',\n    SIZE = 10MB,\n    FILEGROWTH = 5MB\n)\nCOLLATE Japanese_CI_AS;\nGO<\/code><\/pre>\n\n\n\n<div class=\"balloon-wrap\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/ceo-sugasawa.jpg\" alt=\"\u4ee3\u8868\u83c5\u6fa4\">\n    <span class=\"balloon-name\">\u4ee3\u8868\u83c5\u6fa4<\/span>\n  <\/div>\n  <div class=\"balloon-body\">\u521d\u5b66\u8005\u306e\u3046\u3061\u306f\u300cCREATE DATABASE \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d;\u300d\u306e1\u884c\u3067\u5341\u5206\u3067\u3059\u3002\u8a73\u7d30\u30aa\u30d7\u30b7\u30e7\u30f3\u306fDBA\u304c\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3092\u3059\u308b\u6bb5\u968e\u3067\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002\u307e\u305a\u30b7\u30f3\u30d7\u30eb\u306a\u69cb\u6587\u304b\u3089\u59cb\u3081\u3066\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u62e1\u5f35\u3057\u3066\u3044\u304f\u306e\u304c\u30b3\u30c4\u3067\u3059\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"background:#f0fdf4;border:1px solid #22c55e;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:18px;\">&#128161;<\/span>\n    <strong style=\"color:#16a34a;font-size:15px;\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306e\u547d\u540d\u898f\u5247<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">SQL Server\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306f\u30b9\u30da\u30fc\u30b9\u3092\u542b\u3081\u306a\u3044\u306e\u304c\u57fa\u672c\u3067\u3059\u3002\u5358\u8a9e\u306e\u533a\u5207\u308a\u306f\u30a2\u30f3\u30c0\u30fc\u30b9\u30b3\u30a2\uff08_\uff09\u307e\u305f\u306f\u30ad\u30e3\u30e1\u30eb\u30b1\u30fc\u30b9\uff08SampleDB\uff09\u3092\u4f7f\u3044\u307e\u3059\u3002\u307e\u305f\u3001SQL Server\u306e\u4e88\u7d04\u8a9e\uff08SELECT\u3001TABLE\u7b49\uff09\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306b\u4f7f\u3048\u306a\u3044\u305f\u3081\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-05\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">05<\/span>\n  <span class=\"section-label\" style=\"display:block;\">CREATE TABLE<\/span>\n  <span class=\"section-title\" style=\"display:block;\">\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u3068\u30c7\u30fc\u30bf\u578b<\/span>\n  <span class=\"section-desc\">CREATE TABLE\u6587\u3068\u4ee3\u8868\u7684\u306a\u30c7\u30fc\u30bf\u578b\u3092\u899a\u3048\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u305f\u3089\u3001\u6b21\u306f\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u300c\u30c6\u30fc\u30d6\u30eb\u300d\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u306fExcel\u306e\u30b7\u30fc\u30c8\u306b\u4f8b\u3048\u3089\u308c\u307e\u3059\u3002<strong>\u5217\uff08\u30ab\u30e9\u30e0\uff09<\/strong>\u304c\u30c7\u30fc\u30bf\u306e\u7a2e\u985e\u3092\u5b9a\u7fa9\u3057\u3001<strong>\u884c\uff08\u30ec\u30b3\u30fc\u30c9\uff09<\/strong>\u304c\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5-1. GUI\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u2460 \u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff08SampleDB\uff09\u3092\u5c55\u958b\u3057\u3001\u300c\u30c6\u30fc\u30d6\u30eb\u300d\u30d5\u30a9\u30eb\u30c0\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2461 \u300c\u30c6\u30fc\u30d6\u30eb\u3092\u65b0\u898f\u4f5c\u6210\u300d\u2192\u300c\u30c6\u30fc\u30d6\u30eb...\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2462 \u30c6\u30fc\u30d6\u30eb\u30c7\u30b6\u30a4\u30ca\u30fc\u304c\u958b\u304d\u307e\u3059\u3002\u300c\u5217\u540d\u300d\u300c\u30c7\u30fc\u30bf\u578b\u300d\u300cNULL \u3092\u8a31\u5bb9\u300d\u306e3\u3064\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2463 \u4e3b\u30ad\u30fc\uff08PRIMARY KEY\uff09\u3092\u8a2d\u5b9a\u3059\u308b\u306b\u306f\u3001\u8a72\u5f53\u884c\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u4e3b\u30ad\u30fc\u306e\u8a2d\u5b9a\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2464 Ctrl+S\u3067\u4fdd\u5b58\u3059\u308b\u3068\u3001\u30c6\u30fc\u30d6\u30eb\u540d\u306e\u5165\u529b\u3092\u6c42\u3081\u3089\u308c\u307e\u3059\u3002\u540d\u524d\u3092\u5165\u529b\u3057\u3066OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5-2. CREATE TABLE\u6587\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL\u3067\u306e\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u306f\u5b9f\u52d9\u3067\u3088\u304f\u4f7f\u3044\u307e\u3059\u3002\u5b9a\u7fa9\u3092\u30b3\u30fc\u30c9\u3068\u3057\u3066\u6b8b\u305b\u308b\u305f\u3081\u3001\u5f8c\u304b\u3089\u518d\u73fe\u30fb\u6539\u5909\u304c\u3057\u3084\u3059\u3044\u5229\u70b9\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9078\u629e\nUSE SampleDB;\nGO\n\n-- \u9867\u5ba2\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\nCREATE TABLE Customers (\n    CustomerID    INT           NOT NULL IDENTITY(1,1),  -- \u81ea\u52d5\u63a1\u756a\n    CustomerName  NVARCHAR(100) NOT NULL,                -- \u6c0f\u540d\uff08\u6700\u5927100\u6587\u5b57\uff09\n    Email         NVARCHAR(255) NULL,                   -- \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\uff08\u4efb\u610f\uff09\n    Phone         NVARCHAR(20)  NULL,                   -- \u96fb\u8a71\u756a\u53f7\uff08\u4efb\u610f\uff09\n    City          NVARCHAR(50)  NULL,                   -- \u90fd\u5e02\u540d\n    CreatedAt     DATETIME2     NOT NULL DEFAULT GETDATE(),  -- \u767b\u9332\u65e5\u6642\uff08\u81ea\u52d5\uff09\n    CONSTRAINT PK_Customers PRIMARY KEY (CustomerID)   -- \u4e3b\u30ad\u30fc\u5236\u7d04\n);\nGO\n\n-- \u6ce8\u6587\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\nCREATE TABLE Orders (\n    OrderID       INT           NOT NULL IDENTITY(1,1),\n    CustomerID    INT           NOT NULL,               -- \u5916\u90e8\u30ad\u30fc\uff08\u9867\u5ba2\u3068\u7d10\u4ed8\u3051\uff09\n    OrderDate     DATE          NOT NULL DEFAULT GETDATE(),\n    TotalAmount   DECIMAL(10,2) NOT NULL DEFAULT 0,\n    Status        NVARCHAR(20)  NOT NULL DEFAULT 'pending',\n    CONSTRAINT PK_Orders PRIMARY KEY (OrderID),\n    CONSTRAINT FK_Orders_Customers FOREIGN KEY (CustomerID)\n        REFERENCES Customers(CustomerID)\n);\nGO<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5-3. \u4e3b\u306a\u30c7\u30fc\u30bf\u578b\u4e00\u89a7<\/h3>\n\n\n\n<table>\n<thead><tr><th>\u30c7\u30fc\u30bf\u578b<\/th><th>\u7528\u9014<\/th><th>\u4f8b<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>INT<\/td><td>\u6574\u6570\uff08-2,147,483,648 \u301c 2,147,483,647\uff09<\/td><td>ID\u3001\u6570\u91cf\u3001\u5e74\u9f62<\/td><\/tr>\n<tr><td>BIGINT<\/td><td>\u5927\u304d\u306a\u6574\u6570<\/td><td>\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u306e\u9023\u756aID<\/td><\/tr>\n<tr><td>DECIMAL(p,s)<\/td><td>\u7cbe\u5ea6p\u30fb\u5c0f\u6570\u90e8\u6841\u6570s\u306e\u56fa\u5b9a\u5c0f\u6570\u70b9\u6570<\/td><td>DECIMAL(10,2) \u2192 \u91d1\u984d\uff08\u5186\uff09<\/td><\/tr>\n<tr><td>NVARCHAR(n)<\/td><td>Unicode\u6587\u5b57\u5217\uff08\u6700\u5927n\u6587\u5b57\uff09<\/td><td>NVARCHAR(100) \u2192 \u6c0f\u540d\u30fb\u30bf\u30a4\u30c8\u30eb<\/td><\/tr>\n<tr><td>VARCHAR(n)<\/td><td>ASCII\u6587\u5b57\u5217\uff08\u6700\u5927n\u6587\u5b57\uff09<\/td><td>VARCHAR(50) \u2192 \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/td><\/tr>\n<tr><td>DATE<\/td><td>\u65e5\u4ed8\uff08YYYY-MM-DD\uff09<\/td><td>\u751f\u5e74\u6708\u65e5\u30fb\u6ce8\u6587\u65e5<\/td><\/tr>\n<tr><td>DATETIME2<\/td><td>\u65e5\u6642\uff08\u6700\u5927\u7cbe\u5ea6\uff09<\/td><td>\u4f5c\u6210\u65e5\u6642\u30fb\u66f4\u65b0\u65e5\u6642<\/td><\/tr>\n<tr><td>BIT<\/td><td>1\/0\u306e\u30d6\u30fc\u30eb\u5024<\/td><td>\u30d5\u30e9\u30b0\u30fb\u6709\u52b9\/\u7121\u52b9<\/td><\/tr>\n<tr><td>UNIQUEIDENTIFIER<\/td><td>GUID\uff08\u30b0\u30ed\u30fc\u30d0\u30eb\u4e00\u610f\u8b58\u5225\u5b50\uff09<\/td><td>\u5206\u6563\u30b7\u30b9\u30c6\u30e0\u306eID<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>IDENTITY\uff08\u81ea\u52d5\u63a1\u756a\uff09<\/strong>\uff1a\u30c6\u30fc\u30d6\u30eb\u306b\u884c\u304c\u8ffd\u52a0\u3055\u308c\u308b\u305f\u3073\u306b\u81ea\u52d5\u7684\u306b\u9023\u756a\u3092\u632f\u308bSQL Server\u306e\u6a5f\u80fd\u3002IDENTITY(1,1)\u306f\u300c1\u304b\u3089\u59cb\u3081\u30661\u305a\u3064\u5897\u3084\u3059\u300d\u3068\u3044\u3046\u610f\u5473\u3002\u4e3b\u30ad\u30fc\u5217\u306b\u3088\u304f\u4f7f\u308f\u308c\u308b\u3002\u65b0\u3057\u304f\u8ffd\u52a0\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u306eID\u3092\u30d7\u30ed\u30b0\u30e9\u30e0\u304b\u3089\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001INSERT\u76f4\u5f8c\u306bSELECT SCOPE_IDENTITY()\u3092\u5b9f\u884c\u3059\u308b\u3002<\/p>\n<\/div>\n\n\n\n<div style=\"background:#f0fdf4;border:1px solid #22c55e;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:18px;\">&#128161;<\/span>\n    <strong style=\"color:#16a34a;font-size:15px;\">NVARCHAR\u3068VARCHAR\u306e\u4f7f\u3044\u5206\u3051<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">NVARCHAR\uff08N\uff1dNational = Unicode\u5bfe\u5fdc\uff09\u306f\u65e5\u672c\u8a9e\u30fb\u4e2d\u56fd\u8a9e\u30fb\u7d75\u6587\u5b57\u306a\u3069\u591a\u30d0\u30a4\u30c8\u6587\u5b57\u3092\u683c\u7d0d\u3067\u304d\u307e\u3059\u3002VARCHAR\u306fASCII\u6587\u5b57\u5c02\u7528\u30671\u6587\u5b571\u30d0\u30a4\u30c8\u3067\u3059\u304c\u3001\u683c\u7d0d\u52b9\u7387\u304c\u9ad8\u3044\u3002\u65e5\u672c\u8a9e\u3092\u542b\u3080\u53ef\u80fd\u6027\u304c\u3042\u308b\u5217\u306fNVARCHAR\u3092\u4f7f\u3046\u306e\u304c\u5b89\u5168\u3067\u3059\u3002\u305f\u3060\u3057NVARCHAR\u306fVARCHAR\u306e2\u500d\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u3092\u6d88\u8cbb\u3059\u308b\u70b9\u306b\u6ce8\u610f\u3002<\/p>\n<\/div>\n\n\n\n<div class=\"balloon-wrap is-right\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/yamazaki-avatar.png\" alt=\"AI\u9b3c\u7ba1\u7406\u5c71\u5d0e\">\n    <span class=\"balloon-name\">AI\u9b3c\u7ba1\u7406\u5c71\u5d0e<\/span>\n  <\/div>\n  <div class=\"balloon-body\">\u30c6\u30fc\u30d6\u30eb\u8a2d\u8a08\u306e\u6bb5\u968e\u3067\u30c7\u30fc\u30bf\u578b\u3092\u9069\u5207\u306b\u9078\u3076\u3053\u3068\u304c\u3001\u5f8c\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u6574\u5408\u6027\u306b\u5927\u304d\u304f\u5f71\u97ff\u3057\u307e\u3059\u3002\u300c\u3068\u308a\u3042\u3048\u305aNVARCHAR(MAX)\u300d\u3068\u3044\u3046\u8a2d\u8a08\u306f\u907f\u3051\u3066\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u9577\u3092\u898b\u7a4d\u3082\u3063\u3066\u8a2d\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-06\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">06<\/span>\n  <span class=\"section-label\" style=\"display:block;\">CRUD<\/span>\n  <span class=\"section-title\" style=\"display:block;\">INSERT\u30fbSELECT\u30fbUPDATE\u30fbDELETE\u6587<\/span>\n  <span class=\"section-desc\">\u30c7\u30fc\u30bf\u64cd\u4f5c\u306e\u57fa\u672c4\u547d\u4ee4\u3092\u5b8c\u5168\u30de\u30b9\u30bf\u30fc<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u57fa\u672c\u306f4\u3064\u306e\u547d\u4ee4\u306b\u96c6\u7d04\u3055\u308c\u307e\u3059\u3002<strong>INSERT\uff08\u8ffd\u52a0\uff09\u30fbSELECT\uff08\u53d6\u5f97\uff09\u30fbUPDATE\uff08\u66f4\u65b0\uff09\u30fbDELETE\uff08\u524a\u9664\uff09<\/strong>\u2014\u2014\u3053\u306e4\u3064\u3092\u5408\u308f\u305b\u3066\u300cCRUD\u64cd\u4f5c\u300d\u3068\u547c\u3073\u307e\u3059\u3002\u5b9f\u52d9\u3067\u4f7f\u3046SQL\u306e9\u5272\u306f\u3053\u306e4\u547d\u4ee4\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>DML\uff08\u30c7\u30fc\u30bf\u64cd\u4f5c\u8a00\u8a9e\uff09<\/strong>\uff1aData Manipulation Language\u306e\u7565\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u683c\u7d0d\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3059\u308b\u305f\u3081\u306eSQL\u547d\u4ee4\u7fa4\u3002INSERT\uff08\u633f\u5165\uff09\u30fbSELECT\uff08\u53d6\u5f97\uff09\u30fbUPDATE\uff08\u66f4\u65b0\uff09\u30fbDELETE\uff08\u524a\u9664\uff09\u304c\u4ee3\u8868\u7684\u306aDML\u547d\u4ee4\u3002\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u3067\u306f\u306a\u304f\u300c\u30c6\u30fc\u30d6\u30eb\u306b\u5165\u3063\u3066\u3044\u308b\u30c7\u30fc\u30bf\u81ea\u4f53\u300d\u3092\u64cd\u4f5c\u3059\u308b\u70b9\u304cDDL\u3068\u306e\u9055\u3044\u3002<\/p>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">6-1. INSERT\u6587 \u2014 \u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">INSERT\u6587\u306f\u30c6\u30fc\u30d6\u30eb\u306b\u65b0\u3057\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5217\u540d\u3092\u660e\u793a\u3059\u308b\u5f62\u5f0f\u304c\u6700\u3082\u5b89\u5168\u3067\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u57fa\u672c\u7684\u306aINSERT\u6587\uff081\u4ef6\u8ffd\u52a0\uff09\nINSERT INTO Customers (CustomerName, Email, Phone, City)\nVALUES ('\u5c71\u7530 \u592a\u90ce', 'yamada@example.com', '090-1234-5678', '\u6771\u4eac');\n\n-- \u8907\u6570\u4ef6\u3092\u4e00\u5ea6\u306b\u8ffd\u52a0\uff08SQL Server 2008\u4ee5\u964d\uff09\nINSERT INTO Customers (CustomerName, Email, Phone, City)\nVALUES\n    ('\u9234\u6728 \u82b1\u5b50', 'suzuki@example.com', '080-9876-5432', '\u5927\u962a'),\n    ('\u7530\u4e2d \u4e00\u90ce', 'tanaka@example.com', '070-1111-2222', '\u540d\u53e4\u5c4b'),\n    ('\u4f50\u85e4 \u7f8e\u54b2', 'sato@example.com',   NULL,             '\u798f\u5ca1');\n\n-- \u8ffd\u52a0\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u306eID\u3092\u53d6\u5f97\nSELECT SCOPE_IDENTITY() AS NewCustomerID;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">6-2. SELECT\u6587 \u2014 \u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT\u6587\u306f\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002\u6700\u3082\u3088\u304f\u4f7f\u3046SQL\u547d\u4ee4\u3067\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u5168\u5217\u30fb\u5168\u4ef6\u3092\u53d6\u5f97\uff08\u672c\u756aDB\u3067\u306f\u8981\u6ce8\u610f\uff09\nSELECT * FROM Customers;\n\n-- \u7279\u5b9a\u306e\u5217\u3060\u3051\u53d6\u5f97\nSELECT CustomerID, CustomerName, City\nFROM Customers;\n\n-- \u5217\u306b\u5225\u540d\uff08\u30a8\u30a4\u30ea\u30a2\u30b9\uff09\u3092\u4ed8\u3051\u308b\nSELECT\n    CustomerID   AS ID,\n    CustomerName AS \u6c0f\u540d,\n    Email        AS \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9,\n    City         AS \u90fd\u5e02\nFROM Customers;\n\n-- \u91cd\u8907\u3092\u9664\u3044\u305f\u4e00\u89a7\uff08DISTINCT\uff09\nSELECT DISTINCT City FROM Customers;\n\n-- \u4ef6\u6570\u3092\u53d6\u5f97\nSELECT COUNT(*) AS \u9867\u5ba2\u6570 FROM Customers;\n\n-- \u4e26\u3073\u9806\u3092\u6307\u5b9a\nSELECT * FROM Customers\nORDER BY CustomerName ASC;   -- \u6607\u9806\uff08ABC\u9806\uff09\n-- ORDER BY CreatedAt DESC;  -- \u964d\u9806\uff08\u6700\u65b0\u9806\uff09<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">6-3. UPDATE\u6587 \u2014 \u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">UPDATE\u6587\u306f\u65e2\u5b58\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u66f4\u65b0\u3057\u307e\u3059\u3002<strong>WHERE\u53e5\u3092\u7701\u7565\u3059\u308b\u3068\u5168\u4ef6\u66f4\u65b0\u3055\u308c\u3066\u3057\u307e\u3046<\/strong>\u305f\u3081\u3001\u5fc5\u305aWHERE\u53e5\u3092\u4ed8\u3051\u308b\u306e\u304c\u57fa\u672c\u30eb\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u7279\u5b9a\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u66f4\u65b0\uff08CustomerID=1\u306e\u9867\u5ba2\u306e\u90fd\u5e02\u3092\u5909\u66f4\uff09\nUPDATE Customers\nSET City = '\u6a2a\u6d5c'\nWHERE CustomerID = 1;\n\n-- \u8907\u6570\u5217\u3092\u540c\u6642\u306b\u66f4\u65b0\nUPDATE Customers\nSET\n    Email = 'yamada.new@example.com',\n    Phone = '090-9999-8888',\n    City  = '\u795e\u5948\u5ddd'\nWHERE CustomerID = 1;\n\n-- \u66f4\u65b0\u524d\u306b\u5f71\u97ff\u4ef6\u6570\u3092\u78ba\u8a8d\u3059\u308b\u30c6\u30af\u30cb\u30c3\u30af\n-- SELECT\u3067\u78ba\u8a8d\u3057\u3066\u304b\u3089UPDATE\u3059\u308b\nSELECT * FROM Customers WHERE City = '\u6771\u4eac';\n-- \u78ba\u8a8d\u5f8c\u306b\u5b9f\u884c\nUPDATE Customers\nSET City = '\u6771\u4eac\u90fd'\nWHERE City = '\u6771\u4eac';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">6-4. DELETE\u6587 \u2014 \u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">DELETE\u6587\u306f\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\u3057\u307e\u3059\u3002UPDATE\u540c\u69d8\u3001<strong>WHERE\u53e5\u306a\u3057\u3067\u5b9f\u884c\u3059\u308b\u3068\u5168\u4ef6\u524a\u9664<\/strong>\u306b\u306a\u308a\u307e\u3059\u3002\u672c\u756aDB\u3067\u306e\u5b9f\u884c\u306f\u7279\u306b\u614e\u91cd\u306b\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u7279\u5b9a\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\nDELETE FROM Customers\nWHERE CustomerID = 5;\n\n-- \u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u8907\u6570\u4ef6\u3092\u524a\u9664\nDELETE FROM Customers\nWHERE City = '\u4e0d\u660e' AND Email IS NULL;\n\n-- \u524a\u9664\u524d\u306b\u5f71\u97ff\u4ef6\u6570\u3092\u78ba\u8a8d\nSELECT COUNT(*) AS \u524a\u9664\u4e88\u5b9a\u4ef6\u6570\nFROM Customers\nWHERE City = '\u4e0d\u660e' AND Email IS NULL;\n\n-- \u30c6\u30fc\u30d6\u30eb\u306e\u5168\u4ef6\u524a\u9664\uff08\u6ce8\u610f: \u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u53ef\u80fd\uff09\nDELETE FROM Customers;\n\n-- \u30c6\u30fc\u30d6\u30eb\u306e\u5168\u4ef6\u524a\u9664\uff08\u9ad8\u901f\u7248: \u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u4e0d\u53ef\uff09\nTRUNCATE TABLE Customers;<\/code><\/pre>\n\n\n\n<div style=\"background:#fef2f2;border:2px solid #dc2626;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:20px;\">&#9888;&#65039;<\/span>\n    <strong style=\"color:#dc2626;font-size:16px;\">UPDATE\u30fbDELETE\u306f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5185\u3067\u5b9f\u884c\u3059\u308b<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">WHERE\u53e5\u306e\u6307\u5b9a\u30df\u30b9\u306b\u3088\u308b\u5168\u4ef6\u66f4\u65b0\u30fb\u5168\u4ef6\u524a\u9664\u3092\u9632\u3050\u305f\u3081\u3001\u672c\u756aDB\u3067\u306eUPDATE\u30fbDELETE\u306f\u5fc5\u305a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u5b9f\u884c\u3057\u307e\u3057\u3087\u3046\u3002\u300cBEGIN TRAN\u300d\u3067\u958b\u59cb\u3057\u3066\u5f71\u97ff\u4ef6\u6570\u3092\u78ba\u8a8d\u3057\u3001\u554f\u984c\u306a\u3051\u308c\u3070\u300cCOMMIT\u300d\u3001\u30df\u30b9\u304c\u3042\u308c\u3070\u300cROLLBACK\u300d\u3067\u53d6\u308a\u6d88\u305b\u307e\u3059\u3002<\/p>\n<\/div>\n\n\n\n<div class=\"balloon-wrap\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/ceo-sugasawa.jpg\" alt=\"\u4ee3\u8868\u83c5\u6fa4\">\n    <span class=\"balloon-name\">\u4ee3\u8868\u83c5\u6fa4<\/span>\n  <\/div>\n  <div class=\"balloon-body\">CRUD\u64cd\u4f5c\u3092\u899a\u3048\u305f\u3089\u3001\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u306f\u300cWHERE\u53e5\u3067\u30c7\u30fc\u30bf\u3092\u7d5e\u308a\u8fbc\u3080\u300d\u3067\u3059\u3002\u30c7\u30fc\u30bf\u304c\u5897\u3048\u308b\u307b\u3069WHERE\u53e5\u306e\u66f8\u304d\u65b9\u304c\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u76f4\u7d50\u3057\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u8a73\u3057\u304f\u8aac\u660e\u3057\u307e\u3059\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-07\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">07<\/span>\n  <span class=\"section-label\" style=\"display:block;\">WHERE CLAUSE<\/span>\n  <span class=\"section-title\" style=\"display:block;\">WHERE\u53e5\u3068\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/span>\n  <span class=\"section-desc\">\u30c7\u30fc\u30bf\u3092\u6761\u4ef6\u3067\u7d5e\u308a\u8fbc\u3080\u6280\u8853\u3092\u7fd2\u5f97\u3059\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">WHERE\u53e5\u306fSQL\u3067\u6700\u3082\u983b\u7e41\u306b\u4f7f\u3046\u6a5f\u80fd\u3067\u3059\u3002\u300c\u3069\u306e\u30c7\u30fc\u30bf\u3092\u5bfe\u8c61\u306b\u3059\u308b\u304b\u300d\u3092\u7d5e\u308a\u8fbc\u3080\u6761\u4ef6\u6307\u5b9a\u3067\u3001SELECT\u30fbUPDATE\u30fbDELETE\u3059\u3079\u3066\u306b\u4ed8\u3051\u3066\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">7-1. WHERE\u53e5\u306e\u57fa\u672c\u69cb\u6587\u3068\u6bd4\u8f03\u6f14\u7b97\u5b50<\/h3>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u6bd4\u8f03\u6f14\u7b97\u5b50\nSELECT * FROM Customers WHERE CustomerID = 1;      -- \u7b49\u3057\u3044\nSELECT * FROM Customers WHERE CustomerID &lt;&gt; 1;     -- \u7b49\u3057\u304f\u306a\u3044\nSELECT * FROM Customers WHERE CustomerID &gt; 10;     -- \u3088\u308a\u5927\u304d\u3044\nSELECT * FROM Customers WHERE CustomerID &gt;= 10;    -- \u4ee5\u4e0a\nSELECT * FROM Customers WHERE CustomerID &lt; 5;      -- \u3088\u308a\u5c0f\u3055\u3044\nSELECT * FROM Customers WHERE CustomerID &lt;= 5;     -- \u4ee5\u4e0b\n\n-- \u7bc4\u56f2\u6307\u5b9a\uff08BETWEEN ... AND\uff09\nSELECT * FROM Orders\nWHERE TotalAmount BETWEEN 1000 AND 50000;\n\n-- \u30ea\u30b9\u30c8\u6307\u5b9a\uff08IN\uff09\nSELECT * FROM Customers\nWHERE City IN ('\u6771\u4eac', '\u5927\u962a', '\u540d\u53e4\u5c4b');\n\n-- NULL\u306e\u78ba\u8a8d\nSELECT * FROM Customers WHERE Email IS NULL;\nSELECT * FROM Customers WHERE Email IS NOT NULL;\n\n-- \u6587\u5b57\u5217\u306e\u90e8\u5206\u4e00\u81f4\uff08LIKE\uff09\nSELECT * FROM Customers WHERE CustomerName LIKE '\u5c71\u7530%';   -- \u524d\u65b9\u4e00\u81f4\nSELECT * FROM Customers WHERE Email LIKE '%@gmail.com';    -- \u5f8c\u65b9\u4e00\u81f4\nSELECT * FROM Customers WHERE CustomerName LIKE '%\u7530%';    -- \u90e8\u5206\u4e00\u81f4\n\n-- \u8907\u5408\u6761\u4ef6\uff08AND\u30fbOR\uff09\nSELECT * FROM Customers\nWHERE City = '\u6771\u4eac' AND Email IS NOT NULL;\n\nSELECT * FROM Customers\nWHERE City = '\u6771\u4eac' OR City = '\u5927\u962a';\n\n-- NOT\u6761\u4ef6\nSELECT * FROM Customers\nWHERE NOT (City = '\u6771\u4eac' OR City = '\u5927\u962a');<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">7-2. ORDER BY\u30fbTOP\u30fbOFFSET FETCH\u306b\u3088\u308b\u4ef6\u6570\u5236\u5fa1<\/h3>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u4e0a\u4f4dN\u4ef6\u3092\u53d6\u5f97\uff08TOP\u53e5\uff09\nSELECT TOP 10 * FROM Customers\nORDER BY CreatedAt DESC;   -- \u6700\u65b0\u306e10\u4ef6\n\n-- \u30da\u30fc\u30b8\u30f3\u30b0\uff08OFFSET FETCH\uff09\nSELECT CustomerID, CustomerName, City\nFROM Customers\nORDER BY CustomerID\nOFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;  -- 21\u301c30\u4ef6\u76ee\n\n-- GROUP BY \u3068\u96c6\u8a08\nSELECT\n    City,\n    COUNT(*)                    AS \u9867\u5ba2\u6570,\n    COUNT(Email)                AS \u30e1\u30fc\u30eb\u767b\u9332\u6570,\n    SUM(CASE WHEN City = '\u6771\u4eac' THEN 1 ELSE 0 END) AS \u6771\u4eac\u6570\nFROM Customers\nGROUP BY City\nHAVING COUNT(*) &gt;= 2          -- \u30b0\u30eb\u30fc\u30d7\u5f8c\u306e\u7d5e\u308a\u8fbc\u307f\nORDER BY \u9867\u5ba2\u6570 DESC;<\/code><\/pre>\n\n\n\n<div style=\"background:#f0fdf4;border:1px solid #22c55e;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:18px;\">&#128161;<\/span>\n    <strong style=\"color:#16a34a;font-size:15px;\">WHERE\u3068HAVING\u306e\u9055\u3044<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">WHERE\u306fGROUP BY\u306e\u524d\u306b\u30ec\u30b3\u30fc\u30c9\u3092\u7d5e\u308a\u8fbc\u3080\uff08\u500b\u5225\u884c\u3078\u306e\u6761\u4ef6\uff09\u3002HAVING\u306fGROUP BY\u5f8c\u306b\u96c6\u8a08\u7d50\u679c\u306b\u6761\u4ef6\u3092\u304b\u3051\u308b\uff08\u30b0\u30eb\u30fc\u30d7\u3078\u306e\u6761\u4ef6\uff09\u3002\u300c\u6771\u4eac\u306e\u9867\u5ba2\u306e\u307f\u3067\u96c6\u8a08\u3057\u305f\u3044\u300d\u2192WHERE\u3002\u300c\u96c6\u8a08\u3057\u305f\u7d50\u679c\u304c10\u4ef6\u4ee5\u4e0a\u306e\u30b0\u30eb\u30fc\u30d7\u3060\u3051\u8868\u793a\u3057\u305f\u3044\u300d\u2192HAVING\u3002<\/p>\n<\/div>\n\n\n\n<div class=\"balloon-wrap is-right\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/yamazaki-avatar.png\" alt=\"AI\u9b3c\u7ba1\u7406\u5c71\u5d0e\">\n    <span class=\"balloon-name\">AI\u9b3c\u7ba1\u7406\u5c71\u5d0e<\/span>\n  <\/div>\n  <div class=\"balloon-body\">LIKE\u306b\u3088\u308b\u3042\u3044\u307e\u3044\u691c\u7d22\u306f\u30b7\u30f3\u30d7\u30eb\u3067\u4fbf\u5229\u3067\u3059\u304c\u3001\u5148\u982d\u304c\u300c%\u300d\uff08\u524d\u5f8c\u4e00\u81f4\u30fb\u5f8c\u65b9\u4e00\u81f4\uff09\u306e\u5834\u5408\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u52b9\u304b\u305a\u691c\u7d22\u901f\u5ea6\u304c\u843d\u3061\u307e\u3059\u3002\u5927\u91cf\u30c7\u30fc\u30bf\u3092\u6271\u3046\u672c\u756a\u74b0\u5883\u3067\u306f\u3001\u5168\u6587\u691c\u7d22\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08FULLTEXT\uff09\u306e\u5229\u7528\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-08\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">08<\/span>\n  <span class=\"section-label\" style=\"display:block;\">JOIN<\/span>\n  <span class=\"section-title\" style=\"display:block;\">JOIN\u306b\u3088\u308b\u30c6\u30fc\u30d6\u30eb\u7d50\u5408<\/span>\n  <span class=\"section-desc\">\u8907\u6570\u30c6\u30fc\u30d6\u30eb\u3092\u6a2a\u65ad\u3057\u3066\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u306e\u304c<strong>JOIN\uff08\u7d50\u5408\uff09<\/strong>\u3067\u3059\u3002\u5b9f\u52d9\u306eSQL\u3067\u306f\u3001JOIN\u629c\u304d\u3067\u306f\u66f8\u3051\u306a\u3044\u30af\u30a8\u30ea\u306e\u65b9\u304c\u591a\u3044\u305f\u3081\u3001\u5fc5\u305a\u7fd2\u5f97\u3057\u3066\u304a\u304d\u305f\u3044\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">8-1. JOIN\u306e\u7a2e\u985e\u3068\u4f7f\u3044\u5206\u3051<\/h3>\n\n\n\n<div class=\"g-flow-row\" style=\"margin:24px 0;\">\n  <div class=\"g-flow-item\"><strong>INNER JOIN<\/strong><br><span style=\"font-size:12px;\">\u4e21\u30c6\u30fc\u30d6\u30eb\u306b<br>\u4e00\u81f4\u3059\u308b\u3082\u306e<br>\u306e\u307f\u8fd4\u3059<\/span><\/div>\n  <div class=\"g-flow-arrow\">&#8594;<\/div>\n  <div class=\"g-flow-item\"><strong>LEFT JOIN<\/strong><br><span style=\"font-size:12px;\">\u5de6\u30c6\u30fc\u30d6\u30eb\u5168\u4ef6<br>+ \u53f3\u30c6\u30fc\u30d6\u30eb\u3067<br>\u4e00\u81f4\u3059\u308b\u3082\u306e<\/span><\/div>\n  <div class=\"g-flow-arrow\">&#8594;<\/div>\n  <div class=\"g-flow-item\"><strong>RIGHT JOIN<\/strong><br><span style=\"font-size:12px;\">\u53f3\u30c6\u30fc\u30d6\u30eb\u5168\u4ef6<br>+ \u5de6\u30c6\u30fc\u30d6\u30eb\u3067<br>\u4e00\u81f4\u3059\u308b\u3082\u306e<\/span><\/div>\n  <div class=\"g-flow-arrow\">&#8594;<\/div>\n  <div class=\"g-flow-item\"><strong>FULL OUTER JOIN<\/strong><br><span style=\"font-size:12px;\">\u4e21\u30c6\u30fc\u30d6\u30eb\u306e<br>\u5168\u4ef6<br>\uff08null\u542b\u3080\uff09<\/span><\/div>\n<\/div>\n\n\n\n<table>\n<thead><tr><th>JOIN\u7a2e\u985e<\/th><th>\u8fd4\u3055\u308c\u308b\u30c7\u30fc\u30bf<\/th><th>\u5178\u578b\u7684\u306a\u4f7f\u3044\u6240<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>INNER JOIN<\/td><td>\u4e21\u30c6\u30fc\u30d6\u30eb\u3067\u6761\u4ef6\u304c\u4e00\u81f4\u3059\u308b\u884c\u306e\u307f<\/td><td>\u6ce8\u6587\u4e00\u89a7\u306b\u9867\u5ba2\u540d\u3092\u4ed8\u3051\u3066\u8868\u793a<\/td><\/tr>\n<tr><td>LEFT JOIN<\/td><td>\u5de6\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u884c + \u4e00\u81f4\u3059\u308b\u53f3\u30c6\u30fc\u30d6\u30eb\u306e\u884c\uff08\u306a\u3051\u308c\u3070NULL\uff09<\/td><td>\u9867\u5ba2\u5168\u54e1\u306e\u6ce8\u6587\u4ef6\u6570\uff08\u6ce8\u6587\u30bc\u30ed\u306e\u9867\u5ba2\u3082\u542b\u3080\uff09<\/td><\/tr>\n<tr><td>RIGHT JOIN<\/td><td>\u53f3\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u884c + \u4e00\u81f4\u3059\u308b\u5de6\u30c6\u30fc\u30d6\u30eb\u306e\u884c<\/td><td>LEFT JOIN\u3067\u9806\u5e8f\u3092\u9006\u306b\u3059\u308b\u611f\u899a\u3067\u4f7f\u3046\u3053\u3068\u304c\u591a\u3044<\/td><\/tr>\n<tr><td>FULL OUTER JOIN<\/td><td>\u4e21\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u884c\uff08\u3069\u3061\u3089\u304b\u306b\u3057\u304b\u306a\u3044\u884c\u306fNULL\uff09<\/td><td>\u30de\u30b9\u30bf\u306e\u7a81\u5408\u30fb\u30c7\u30fc\u30bf\u30af\u30ec\u30f3\u30b8\u30f3\u30b0<\/td><\/tr>\n<tr><td>CROSS JOIN<\/td><td>\u5168\u7d44\u307f\u5408\u308f\u305b\uff08\u30c7\u30ab\u30eb\u30c8\u7a4d\uff09<\/td><td>\u30ab\u30ec\u30f3\u30c0\u30fc\u30c6\u30fc\u30d6\u30eb\u306e\u751f\u6210\u306a\u3069\u7279\u6b8a\u7528\u9014<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n\n<h3 class=\"wp-block-heading\">8-2. JOIN\u306e\u66f8\u304d\u65b9<\/h3>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- INNER JOIN: \u9867\u5ba2\u3068\u6ce8\u6587\u3092\u7d50\u5408\uff08\u4e21\u65b9\u306b\u5b58\u5728\u3059\u308b\u3082\u306e\uff09\nSELECT\n    c.CustomerID,\n    c.CustomerName,\n    c.City,\n    o.OrderID,\n    o.OrderDate,\n    o.TotalAmount\nFROM Customers AS c\nINNER JOIN Orders AS o ON c.CustomerID = o.CustomerID\nORDER BY o.OrderDate DESC;\n\n-- LEFT JOIN: \u6ce8\u6587\u30bc\u30ed\u306e\u9867\u5ba2\u3082\u542b\u3081\u3066\u5168\u9867\u5ba2\u306e\u6ce8\u6587\u6570\u3092\u8868\u793a\nSELECT\n    c.CustomerID,\n    c.CustomerName,\n    COUNT(o.OrderID)  AS \u6ce8\u6587\u4ef6\u6570,\n    SUM(o.TotalAmount) AS \u7d2f\u8a08\u91d1\u984d\nFROM Customers AS c\nLEFT JOIN Orders AS o ON c.CustomerID = o.CustomerID\nGROUP BY c.CustomerID, c.CustomerName\nORDER BY \u6ce8\u6587\u4ef6\u6570 DESC;\n\n-- 3\u30c6\u30fc\u30d6\u30eb\u306eJOIN\u4f8b\uff08\u9867\u5ba2\u30fb\u6ce8\u6587\u30fb\u5546\u54c1\uff09\nSELECT\n    c.CustomerName,\n    o.OrderDate,\n    p.ProductName,\n    od.Quantity,\n    od.UnitPrice,\n    (od.Quantity * od.UnitPrice) AS \u5c0f\u8a08\nFROM Customers AS c\nINNER JOIN Orders AS o     ON c.CustomerID = o.CustomerID\nINNER JOIN OrderDetails od ON o.OrderID = od.OrderID\nINNER JOIN Products p      ON od.ProductID = p.ProductID\nWHERE o.OrderDate &gt;= '2026-01-01'\nORDER BY o.OrderDate DESC;<\/code><\/pre>\n\n\n\n<div style=\"background:#f8f9fa;border-left:4px solid #6b7280;border-radius:0 8px 8px 0;padding:16px 20px;margin:20px 0;\">\n  <p style=\"margin:0 0 4px;font-size:13px;font-weight:700;color:#6b7280;letter-spacing:1px;\">&#128218; \u7528\u8a9e\u89e3\u8aac<\/p>\n  <p style=\"margin:0;font-size:15px;line-height:1.7;\"><strong>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3<\/strong>\uff1a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3059\u308b\u4e00\u9023\u306e\u51e6\u7406\u3092\u3072\u3068\u307e\u3068\u3081\u306b\u3057\u305f\u5358\u4f4d\u3002\u300c\u9001\u91d1\u51e6\u7406\u300d\u3092\u4f8b\u306b\u3059\u308b\u3068\u300c\u53e3\u5ea7A\u304b\u3089\u5f15\u304d\u843d\u3068\u3059\u300d\u300c\u53e3\u5ea7B\u3078\u5165\u91d1\u3059\u308b\u300d\u306e2\u64cd\u4f5c\u3092\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3068\u3057\u3066\u307e\u3068\u3081\u3001\u4e21\u65b9\u6210\u529f\u3057\u305f\u5834\u5408\u306e\u307fCOMMIT\uff08\u78ba\u5b9a\uff09\u3001\u4e00\u65b9\u3067\u3082\u5931\u6557\u3057\u305f\u3089ROLLBACK\uff08\u53d6\u308a\u6d88\u3057\uff09\u3059\u308b\u3053\u3068\u3067\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u3092\u4fdd\u3064\u3002ACID\u7279\u6027\uff08\u539f\u5b50\u6027\u30fb\u4e00\u8cab\u6027\u30fb\u72ec\u7acb\u6027\u30fb\u6c38\u7d9a\u6027\uff09\u3092\u4fdd\u8a3c\u3059\u308b\u4ed5\u7d44\u307f\u3002<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">JOIN\u3092\u6b63\u3057\u304f\u66f8\u304f\u306b\u306f<strong>\u300c\u3069\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u3069\u306e\u5217\u304c\u3001\u5225\u30c6\u30fc\u30d6\u30eb\u306e\u3069\u306e\u5217\u3068\u4e00\u81f4\u3059\u308b\u304b\u300d<\/strong>\u3092\u5148\u306b\u6574\u7406\u3059\u308b\u3053\u3068\u304c\u5927\u5207\u3067\u3059\u3002\u3053\u306e\u5bfe\u5fdc\u95a2\u4fc2\u304c\u300c\u5916\u90e8\u30ad\u30fc\uff08FOREIGN KEY\uff09\u300d\u3068\u3057\u3066\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308c\u3070\u3001SSMS\u306e\u30c6\u30fc\u30d6\u30eb\u30c7\u30b6\u30a4\u30ca\u30fc\u304b\u3089\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"balloon-wrap\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/ceo-sugasawa.jpg\" alt=\"\u4ee3\u8868\u83c5\u6fa4\">\n    <span class=\"balloon-name\">\u4ee3\u8868\u83c5\u6fa4<\/span>\n  <\/div>\n  <div class=\"balloon-body\">JOIN\u304c\u82e6\u624b\u306a\u65b9\u306b\u591a\u3044\u306e\u304c\u300c\u30c6\u30fc\u30d6\u30eb\u306e\u95a2\u4fc2\u56f3\u3092\u982d\u306b\u63cf\u3051\u3066\u3044\u306a\u3044\u300d\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002\u306f\u3058\u3081\u306e\u3046\u3061\u306f\u7d19\u306b\u300c\u3069\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u3069\u306e\u5217\u3067\u3064\u306a\u304c\u3063\u3066\u3044\u308b\u304b\u300d\u3092\u56f3\u793a\u3057\u3066\u304b\u3089SQL\u3092\u66f8\u304f\u7fd2\u6163\u3092\u3064\u3051\u308b\u3068\u3001\u8ff7\u3044\u304c\u5927\u5e45\u306b\u6e1b\u308a\u307e\u3059\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"background:#f0fdf4;border:1px solid #22c55e;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:18px;\">&#128161;<\/span>\n    <strong style=\"color:#16a34a;font-size:15px;\">JOIN\u306e\u30c7\u30d0\u30c3\u30b0\u30c6\u30af\u30cb\u30c3\u30af<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">JOIN\u304c\u6b63\u3057\u304f\u66f8\u3051\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3059\u308b\u306b\u306f\u3001\u307e\u305a\u6700\u3082\u5358\u7d14\u306a\u5f62\uff082\u30c6\u30fc\u30d6\u30eb\u306eINNER JOIN\u3060\u3051\uff09\u3067\u5b9f\u884c\u3057\u3066\u307f\u307e\u3059\u3002\u60f3\u5b9a\u3057\u305f\u4ef6\u6570\u304c\u8fd4\u3063\u3066\u304d\u305f\u3089\u5217\u3092\u5897\u3084\u3057\u3001\u60f3\u5b9a\u5916\u306a\u3089ON\u53e5\u306e\u6761\u4ef6\u3092\u898b\u76f4\u3059\u3002\u300c\u30c6\u30fc\u30d6\u30eb\u3092\u4e00\u3064\u305a\u3064\u8db3\u3057\u3066\u3044\u304f\u300d\u30a2\u30d7\u30ed\u30fc\u30c1\u304c\u78ba\u5b9f\u3067\u3059\u3002<\/p>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<div id=\"sec-09\"><\/div>\n<h2 class=\"section-header-img\" style=\"margin:32px 0 24px;border-radius:8px;overflow:hidden;background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);padding:32px 28px;color:#fff;position:relative;border:none;border-left:none;text-align:left;\">\n  <span class=\"section-number\" style=\"display:block;\">09<\/span>\n  <span class=\"section-label\" style=\"display:block;\">AUTO QUERY<\/span>\n  <span class=\"section-title\" style=\"display:block;\">\u30af\u30a8\u30ea\u81ea\u52d5\u4f5c\u6210\u6a5f\u80fd\u306e\u4f7f\u3044\u65b9<\/span>\n  <span class=\"section-desc\">GUI\u304b\u3089SQL\u3092\u81ea\u52d5\u751f\u6210\u3059\u308b\u4fbf\u5229\u306a\u6a5f\u80fd\u3092\u6d3b\u7528\u3059\u308b<\/span>\n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SSMS\u306b\u306f\u3001GUI\u306e\u64cd\u4f5c\u304b\u3089SQL\u3092\u81ea\u52d5\u751f\u6210\u3059\u308b\u6a5f\u80fd\u304c\u8907\u6570\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3092\u77e5\u3063\u3066\u3044\u308b\u3060\u3051\u3067\u3001\u8907\u96d1\u306a\u30af\u30a8\u30ea\u3092\u624b\u66f8\u304d\u3059\u308b\u624b\u9593\u304c\u5927\u5e45\u306b\u7701\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">9-1. \u30c6\u30fc\u30d6\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u81ea\u52d5\u751f\u6210<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e2\u5b58\u30c6\u30fc\u30d6\u30eb\u306eCREATE TABLE\u6587\u3092\u81ea\u52d5\u751f\u6210\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2460 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u3067\u5bfe\u8c61\u30c6\u30fc\u30d6\u30eb\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2461 \u300c\u30c6\u30fc\u30d6\u30eb\u3092\u30b9\u30af\u30ea\u30d7\u30c8\u5316\u300d\u2192\u300cCREATE\u300d\u2192\u300c\u65b0\u3057\u3044\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf\u30fc \u30a6\u30a3\u30f3\u30c9\u30a6\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2462 \u5b8c\u5168\u306aCREATE TABLE\u6587\u304c\u81ea\u52d5\u751f\u6210\u3055\u308c\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u5316\u3084DB\u79fb\u884c\u6642\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">9-2. \u4e0a\u4f4d1000\u884c\u306e\u9078\u629e \/ \u4e0a\u4f4d200\u884c\u306e\u7de8\u96c6<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c6\u30fc\u30d6\u30eb\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u300c\u4e0a\u4f4d1000\u884c\u306e\u9078\u629e\u300d\u3068\u300c\u4e0a\u4f4d200\u884c\u306e\u7de8\u96c6\u300d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u300c\u4e0a\u4f4d1000\u884c\u306e\u9078\u629e\u300d\u306fSELECT TOP (1000) * FROM \u30c6\u30fc\u30d6\u30eb\u540d \u3092\u81ea\u52d5\u5b9f\u884c\u3057\u3001\u30c7\u30fc\u30bf\u3092\u30b0\u30ea\u30c3\u30c9\u3067\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u300c\u4e0a\u4f4d200\u884c\u306e\u7de8\u96c6\u300d\u306f\u76f4\u63a5\u30b0\u30ea\u30c3\u30c9\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c7\u30fc\u30bf\u3092\u7de8\u96c6\u3067\u304d\u308b\u30e2\u30fc\u30c9\u3067\u3059\u3002<strong>SQL\u3092\u66f8\u304b\u305a\u306bInsert\u30fbUpdate\u30fbDelete\u304c\u8996\u899a\u7684\u306b\u3067\u304d\u308b<\/strong>\u305f\u3081\u3001\u958b\u767a\u4e2d\u306e\u30c7\u30fc\u30bf\u64cd\u4f5c\u306b\u91cd\u5b9d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">9-3. \u30af\u30a8\u30ea\u30c7\u30b6\u30a4\u30ca\u30fc\uff08\u30b0\u30e9\u30d5\u30a3\u30ab\u30eb\u306aSELECT\u6587\u4f5c\u6210\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SSMS\u306e\u30af\u30a8\u30ea\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u3001\u53f3\u30af\u30ea\u30c3\u30af\u2192\u300c\u30af\u30a8\u30ea\u3092\u30c7\u30b6\u30a4\u30f3\u3059\u308b\u300d\u3092\u9078\u3076\u3068<strong>\u30b0\u30e9\u30d5\u30a3\u30ab\u30eb\u306a\u30af\u30a8\u30ea\u30c7\u30b6\u30a4\u30ca\u30fc<\/strong>\u304c\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c6\u30fc\u30d6\u30eb\u3092\u30c9\u30e9\u30c3\u30b0&\u30c9\u30ed\u30c3\u30d7\u3067\u30ad\u30e3\u30f3\u30d0\u30b9\u306b\u8ffd\u52a0\u3057\u3001JOIN\u6761\u4ef6\u306f\u30c6\u30fc\u30d6\u30eb\u9593\u306e\u5217\u3092\u30c9\u30e9\u30c3\u30b0\u3067\u7d50\u3076\u3060\u3051\u3067SQL\u304c\u81ea\u52d5\u751f\u6210\u3055\u308c\u307e\u3059\u3002GROUP BY\u30fbORDER BY\u30fbWHERE\u6761\u4ef6\u3082\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3067\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"background:#f0fdf4;border:1px solid #22c55e;border-radius:8px;padding:20px 24px;margin:24px 0;\">\n  <div style=\"display:flex;align-items:center;gap:8px;margin-bottom:12px;\">\n    <span style=\"font-size:18px;\">&#128161;<\/span>\n    <strong style=\"color:#16a34a;font-size:15px;\">\u30af\u30a8\u30ea\u30c7\u30b6\u30a4\u30ca\u30fc\u306e\u5b9f\u7528\u7684\u306a\u4f7f\u3044\u65b9<\/strong>\n  <\/div>\n  <p style=\"margin:0;font-size:15px;line-height:1.8;color:#333;\">\u30af\u30a8\u30ea\u30c7\u30b6\u30a4\u30ca\u30fc\u3067\u5927\u307e\u304b\u306aSELECT\u6587\u3092\u81ea\u52d5\u751f\u6210\u3057\u3066\u304b\u3089\u3001\u4e0b\u90e8\u306eSQL\u7de8\u96c6\u30a8\u30ea\u30a2\u3067\u7d30\u304b\u3044\u4fee\u6b63\u3092\u52a0\u3048\u308b\u300c\u30cf\u30a4\u30d6\u30ea\u30c3\u30c9\u300d\u306a\u4f7f\u3044\u65b9\u304c\u52b9\u7387\u7684\u3067\u3059\u3002JOIN\u306e\u591a\u3044\u8907\u96d1\u306a\u30af\u30a8\u30ea\u306e\u9aa8\u683c\u3092GUI\u3067\u4f5c\u3063\u3066\u3001WHERE\u53e5\u3084\u96c6\u8a08\u95a2\u6570\u3092\u624b\u3067\u8ffd\u8a18\u3059\u308b\u65b9\u6cd5\u304c\u30d7\u30ed\u3067\u3082\u4f7f\u308f\u308c\u307e\u3059\u3002<\/p>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">9-4. \u5b9f\u884c\u30d7\u30e9\u30f3\u306e\u78ba\u8a8d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u52b9\u7387\u3092\u78ba\u8a8d\u30fb\u6539\u5584\u3059\u308b\u306b\u306f\u300c\u5b9f\u884c\u30d7\u30e9\u30f3\u300d\u304c\u6709\u7528\u3067\u3059\u3002Ctrl+L\uff08\u63a8\u5b9a\u5b9f\u884c\u30d7\u30e9\u30f3\u306e\u8868\u793a\uff09\u307e\u305f\u306fCtrl+M\uff08\u5b9f\u969b\u306e\u5b9f\u884c\u30d7\u30e9\u30f3\u306e\u8868\u793a\uff09\u3067\u3001\u30af\u30a8\u30ea\u304c\u3069\u306e\u3088\u3046\u306b\u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3044\u308b\u304b\u3092\u30b0\u30e9\u30d5\u30a3\u30ab\u30eb\u306b\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u884c\u30d7\u30e9\u30f3\u3067\u300cTABLE SCAN\u300d\uff08\u5168\u4ef6\u30b9\u30ad\u30e3\u30f3\uff09\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u52b9\u3044\u3066\u3044\u306a\u3044\u30b5\u30a4\u30f3\u3067\u3059\u3002WHERE\u53e5\u306b\u4f7f\u3046\u5217\u306bINDEX\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3067\u5927\u5e45\u306a\u9ad8\u901f\u5316\u304c\u898b\u8fbc\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<pre style=\"background:#1e1e1e;color:#d4d4d4;padding:20px;border-radius:6px;overflow-x:auto;line-height:1.6;margin:20px 0;font-size:14px;\"><code>-- \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f5c\u6210\nCREATE INDEX IX_Customers_City\nON Customers(City);\n\nCREATE INDEX IX_Customers_Email\nON Customers(Email)\nWHERE Email IS NOT NULL;   -- \u30d5\u30a3\u30eb\u30bf\u30fc\u6e08\u307f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n\n-- \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u4e00\u89a7\u306e\u78ba\u8a8d\nSELECT\n    i.name          AS \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u540d,\n    i.type_desc     AS \u7a2e\u985e,\n    COL_NAME(ic.object_id, ic.column_id) AS \u5217\u540d\nFROM sys.indexes AS i\nJOIN sys.index_columns AS ic\n    ON i.object_id = ic.object_id AND i.index_id = ic.index_id\nWHERE OBJECT_NAME(i.object_id) = 'Customers';<\/code><\/pre>\n\n\n\n<div class=\"balloon-wrap is-right\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/yamazaki-avatar.png\" alt=\"AI\u9b3c\u7ba1\u7406\u5c71\u5d0e\">\n    <span class=\"balloon-name\">AI\u9b3c\u7ba1\u7406\u5c71\u5d0e<\/span>\n  <\/div>\n  <div class=\"balloon-body\">\u30af\u30a8\u30ea\u306e\u81ea\u52d5\u4f5c\u6210\u6a5f\u80fd\u306f\u300cSQL\u3092\u899a\u3048\u306a\u304f\u3066\u3044\u3044\u300d\u305f\u3081\u306e\u3082\u306e\u3067\u306f\u306a\u304f\u3001\u300cSQL\u3092\u901f\u304f\u30fb\u6b63\u78ba\u306b\u66f8\u304f\u305f\u3081\u306e\u88dc\u52a9\u300d\u3068\u3057\u3066\u4f7f\u3046\u306e\u304c\u6b63\u89e3\u3067\u3059\u3002\u81ea\u52d5\u751f\u6210\u3055\u308c\u305fSQL\u3092\u8aad\u3093\u3067\u300c\u306a\u305c\u3053\u3046\u66f8\u304f\u306e\u304b\u300d\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001SQL\u30b9\u30ad\u30eb\u304c\u683c\u6bb5\u306b\u4e0a\u304c\u308a\u307e\u3059\u3002<\/div>\n<\/div>\n\n\n\n<div class=\"balloon-wrap\">\n  <div class=\"balloon-icon\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/ceo-sugasawa.jpg\" alt=\"\u4ee3\u8868\u83c5\u6fa4\">\n    <span class=\"balloon-name\">\u4ee3\u8868\u83c5\u6fa4<\/span>\n  <\/div>\n  <div class=\"balloon-body\">SSMS\u306b\u306f\u4eca\u56de\u7d39\u4ecb\u3057\u305f\u4ee5\u5916\u306b\u3082\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30fb\u30ea\u30b9\u30c8\u30a2\u30fb\u30b8\u30e7\u30d6\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u30fb\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a\u306a\u3069\u3001\u591a\u5f69\u306a\u7ba1\u7406\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3059\u3002\u307e\u305a\u306fCRUD\u64cd\u4f5c\u3068JOIN\u3092\u30de\u30b9\u30bf\u30fc\u3057\u3066\u3001\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u3068\u3057\u3066\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6700\u9069\u5316\u3084\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306b\u9032\u3080\u306e\u304c\u304a\u3059\u3059\u3081\u306e\u30ed\u30fc\u30c9\u30de\u30c3\u30d7\u3067\u3059\u3002<\/div>\n<\/div>\n\n\n\n<div style=\"margin:48px 0 8px;text-align:center;\">\n  <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=h2-banner\" target=\"_blank\" rel=\"noopener\">\n    <img decoding=\"async\" src=\"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-content\/uploads\/2026\/04\/cta_blog.jpg\" alt=\"AI\u9b3c\u7ba1\u7406 \u2014 \u696d\u52d9\u3092AI\u3067\u81ea\u52d5\u5316\" style=\"width:100%;max-width:800px;height:auto;border-radius:8px;display:inline-block;\">\n  <\/a>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"faq\">\u3088\u304f\u3042\u308b\u8cea\u554f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Q. SSMS\u306f\u7121\u6599\u3067\u4f7f\u3048\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A. SSMS\uff08SQL Server Management Studio\uff09\u672c\u4f53\u306f\u5e38\u306b\u7121\u511f\u3067\u63d0\u4f9b\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u305f\u3060\u3057\u63a5\u7d9a\u5148\u306eSQL Server\u306b\u306f\u6709\u511f\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u3082\u3042\u308a\u307e\u3059\u3002\u958b\u767a\u30fb\u5b66\u7fd2\u7528\u9014\u3067\u3042\u308c\u3070SQL Server Developer Edition\uff08\u672c\u756a\u5229\u7528\u4ee5\u5916\u306f\u7121\u511f\uff09\u307e\u305f\u306fSQL Server Express\uff08\u6a5f\u80fd\u5236\u9650\u3042\u308a\u30fb\u672c\u756a\u5229\u7528\u53ef\u80fd\uff09\u3092\u7121\u511f\u3067\u4f7f\u3048\u307e\u3059\u3002\u8cbb\u7528\u3092\u30bc\u30ed\u3067\u59cb\u3081\u305f\u3044\u5834\u5408\u306f\u300cSQL Server Developer + SSMS\u6700\u65b0\u7248\u300d\u306e\u7d44\u307f\u5408\u308f\u305b\u304c\u6700\u3082\u6a5f\u80fd\u7684\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Q. SSMS\u306fMac\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A. SSMS\u306fWindows\u5c02\u7528\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u306e\u305f\u3081\u3001macOS\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002macOS\u3067SQL Server\u3092\u7ba1\u7406\u3057\u305f\u3044\u5834\u5408\u306f\u3001Microsoft\u304c\u63d0\u4f9b\u3059\u308b\u300cAzure Data Studio\u300d\u3092\u4f7f\u3063\u3066\u304f\u3060\u3055\u3044\u3002Azure Data Studio\u306fmacOS\u30fbLinux\u30fbWindows\u306b\u5bfe\u5fdc\u3057\u3066\u304a\u308a\u3001\u57fa\u672c\u7684\u306a\u30af\u30a8\u30ea\u5b9f\u884c\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057SSMS\u3068\u6bd4\u3079\u308b\u3068\u7ba1\u7406\u6a5f\u80fd\u306f\u9650\u5b9a\u7684\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Q. SSMS\u3068SQL Server\u3001\u3069\u3061\u3089\u3092\u5148\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308c\u3070\u3044\u3044\u3067\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A. SQL Server\u3092\u5148\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u305d\u306e\u5f8cSSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002SQL Server\u306fSSMS\u304c\u63a5\u7d9a\u3059\u308b\u5bfe\u8c61\uff08\u30b5\u30fc\u30d0\u30fc\uff09\u306a\u306e\u3067\u3001\u63a5\u7d9a\u5148\u304c\u5b58\u5728\u3057\u306a\u3044\u72b6\u614b\u3067SSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3082\u610f\u5473\u304c\u306a\u3044\u305f\u3081\u3067\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u9806\u5e8f\uff1a\u2460 SQL Server Developer\/Express \u2192 \u2461 SSMS \u2192 \u2462 SSMS\u3092\u8d77\u52d5\u3057\u3066\u63a5\u7d9a\u78ba\u8a8d\u3001\u3068\u3044\u3046\u6d41\u308c\u304c\u6b63\u3057\u3044\u624b\u9806\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Q. SELECT * FROM \u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5b9f\u884c\u3057\u305f\u3089\u5927\u91cf\u30c7\u30fc\u30bf\u304c\u8fd4\u3063\u3066\u304d\u3066\u30d5\u30ea\u30fc\u30ba\u3057\u307e\u3057\u305f\u3002\u3069\u3046\u3059\u308c\u3070\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A. SELECT * FROM \u30c6\u30fc\u30d6\u30eb\u540d \u306f\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u3092\u8fd4\u3059\u305f\u3081\u3001\u6570\u767e\u4e07\u4ef6\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5b9f\u884c\u3059\u308b\u3068SSMS\u304c\u30d5\u30ea\u30fc\u30ba\u3059\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u672c\u756aDB\u3067\u306f\u5e38\u306bSELECT TOP 100 * FROM \u30c6\u30fc\u30d6\u30eb\u540d \u306e\u3088\u3046\u306bTOP\u3067\u4ef6\u6570\u3092\u5236\u9650\u3059\u308b\u304b\u3001WHERE\u53e5\u3067\u7d5e\u308a\u8fbc\u3093\u3067\u304b\u3089\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30d5\u30ea\u30fc\u30ba\u4e2d\u306fSSMS\u306e\u30c4\u30fc\u30eb\u30d0\u30fc\u306e\u8d64\u3044\u300c\u505c\u6b62\u300d\u30dc\u30bf\u30f3\uff08\u307e\u305f\u306fAlt+Break\uff09\u3067\u30af\u30a8\u30ea\u3092\u4e2d\u65ad\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Q. WHERE\u53e5\u3092\u66f8\u304d\u5fd8\u308c\u3066UPDATE\u3092\u5b9f\u884c\u3057\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002\u53d6\u308a\u6d88\u305b\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A. \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\uff08BEGIN TRAN\uff09\u3092\u4f7f\u3063\u3066\u5b9f\u884c\u3057\u3066\u3044\u305f\u5834\u5408\u306f\u3001ROLLBACK TRAN\u3067\u53d6\u308a\u6d88\u305b\u307e\u3059\u3002\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306a\u3057\u3067\u5b9f\u884c\u3057\u3066\u3057\u307e\u3063\u305f\u5834\u5408\u306f\u3001\u539f\u5247\u3068\u3057\u3066\u53d6\u308a\u6d88\u305b\u307e\u305b\u3093\u3002\u305f\u3060\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304c\u5b58\u5728\u3059\u308c\u3070\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304b\u3089\u306e\u5fa9\u5143\u304c\u53ef\u80fd\u3067\u3059\u3002\u672c\u756aDB\u3067\u306f\u5b9a\u671f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u8a2d\u5b9a\u304c\u5fc5\u9808\u3067\u3042\u308b\u7406\u7531\u304c\u3053\u3053\u306b\u3042\u308a\u307e\u3059\u3002\u4eca\u5f8c\u306fUPDATE\u30fbDELETE\u524d\u306b\u5fc5\u305a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u7fd2\u6163\u3092\u8eab\u306b\u3064\u3051\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SSMS\u306f\u7121\u6599\u3067\u4f7f\u3048\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SSMS\uff08SQL Server Management Studio\uff09\u672c\u4f53\u306f\u5e38\u306b\u7121\u511f\u3067\u63d0\u4f9b\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u305f\u3060\u3057\u63a5\u7d9a\u5148\u306eSQL Server\u306b\u306f\u6709\u511f\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u3082\u3042\u308a\u307e\u3059\u3002\u958b\u767a\u30fb\u5b66\u7fd2\u7528\u9014\u3067\u3042\u308c\u3070SQL Server Developer Edition\uff08\u672c\u756a\u5229\u7528\u4ee5\u5916\u306f\u7121\u511f\uff09\u307e\u305f\u306fSQL Server Express\uff08\u6a5f\u80fd\u5236\u9650\u3042\u308a\u30fb\u672c\u756a\u5229\u7528\u53ef\u80fd\uff09\u3092\u7121\u511f\u3067\u4f7f\u3048\u307e\u3059\u3002\u8cbb\u7528\u3092\u30bc\u30ed\u3067\u59cb\u3081\u305f\u3044\u5834\u5408\u306f\u300cSQL Server Developer + SSMS\u6700\u65b0\u7248\u300d\u306e\u7d44\u307f\u5408\u308f\u305b\u304c\u6700\u3082\u6a5f\u80fd\u7684\u3067\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SSMS\u306fMac\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SSMS\u306fWindows\u5c02\u7528\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u306e\u305f\u3081\u3001macOS\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002macOS\u3067SQL Server\u3092\u7ba1\u7406\u3057\u305f\u3044\u5834\u5408\u306f\u3001Microsoft\u304c\u63d0\u4f9b\u3059\u308b\u300cAzure Data Studio\u300d\u3092\u4f7f\u3063\u3066\u304f\u3060\u3055\u3044\u3002Azure Data Studio\u306fmacOS\u30fbLinux\u30fbWindows\u306b\u5bfe\u5fdc\u3057\u3066\u304a\u308a\u3001\u57fa\u672c\u7684\u306a\u30af\u30a8\u30ea\u5b9f\u884c\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057SSMS\u3068\u6bd4\u3079\u308b\u3068\u7ba1\u7406\u6a5f\u80fd\u306f\u9650\u5b9a\u7684\u3067\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SSMS\u3068SQL Server\u3001\u3069\u3061\u3089\u3092\u5148\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308c\u3070\u3044\u3044\u3067\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SQL Server\u3092\u5148\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u305d\u306e\u5f8cSSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002SQL Server\u306fSSMS\u304c\u63a5\u7d9a\u3059\u308b\u5bfe\u8c61\uff08\u30b5\u30fc\u30d0\u30fc\uff09\u306a\u306e\u3067\u3001\u63a5\u7d9a\u5148\u304c\u5b58\u5728\u3057\u306a\u3044\u72b6\u614b\u3067SSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3082\u610f\u5473\u304c\u306a\u3044\u305f\u3081\u3067\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u9806\u5e8f\uff1a\u2460 SQL Server Developer\/Express \u2192 \u2461 SSMS \u2192 \u2462 SSMS\u3092\u8d77\u52d5\u3057\u3066\u63a5\u7d9a\u78ba\u8a8d\u3001\u3068\u3044\u3046\u6d41\u308c\u304c\u6b63\u3057\u3044\u624b\u9806\u3067\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SELECT * FROM \u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5b9f\u884c\u3057\u305f\u3089\u5927\u91cf\u30c7\u30fc\u30bf\u304c\u8fd4\u3063\u3066\u304d\u3066\u30d5\u30ea\u30fc\u30ba\u3057\u307e\u3057\u305f\u3002\u3069\u3046\u3059\u308c\u3070\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SELECT * FROM \u30c6\u30fc\u30d6\u30eb\u540d \u306f\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u3092\u8fd4\u3059\u305f\u3081\u3001\u6570\u767e\u4e07\u4ef6\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5b9f\u884c\u3059\u308b\u3068SSMS\u304c\u30d5\u30ea\u30fc\u30ba\u3059\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u672c\u756aDB\u3067\u306f\u5e38\u306bSELECT TOP 100 * FROM \u30c6\u30fc\u30d6\u30eb\u540d \u306e\u3088\u3046\u306bTOP\u3067\u4ef6\u6570\u3092\u5236\u9650\u3059\u308b\u304b\u3001WHERE\u53e5\u3067\u7d5e\u308a\u8fbc\u3093\u3067\u304b\u3089\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30d5\u30ea\u30fc\u30ba\u4e2d\u306fSSMS\u306e\u30c4\u30fc\u30eb\u30d0\u30fc\u306e\u8d64\u3044\u300c\u505c\u6b62\u300d\u30dc\u30bf\u30f3\uff08\u307e\u305f\u306fAlt+Break\uff09\u3067\u30af\u30a8\u30ea\u3092\u4e2d\u65ad\u3067\u304d\u307e\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"WHERE\u53e5\u3092\u66f8\u304d\u5fd8\u308c\u3066UPDATE\u3092\u5b9f\u884c\u3057\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002\u53d6\u308a\u6d88\u305b\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\uff08BEGIN TRAN\uff09\u3092\u4f7f\u3063\u3066\u5b9f\u884c\u3057\u3066\u3044\u305f\u5834\u5408\u306f\u3001ROLLBACK TRAN\u3067\u53d6\u308a\u6d88\u305b\u307e\u3059\u3002\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306a\u3057\u3067\u5b9f\u884c\u3057\u3066\u3057\u307e\u3063\u305f\u5834\u5408\u306f\u3001\u539f\u5247\u3068\u3057\u3066\u53d6\u308a\u6d88\u305b\u307e\u305b\u3093\u3002\u305f\u3060\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304c\u5b58\u5728\u3059\u308c\u3070\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304b\u3089\u306e\u5fa9\u5143\u304c\u53ef\u80fd\u3067\u3059\u3002\u672c\u756aDB\u3067\u306f\u5b9a\u671f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u8a2d\u5b9a\u304c\u5fc5\u9808\u3067\u3042\u308b\u7406\u7531\u304c\u3053\u3053\u306b\u3042\u308a\u307e\u3059\u3002\u4eca\u5f8c\u306fUPDATE\u30fbDELETE\u524d\u306b\u5fc5\u305a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u7fd2\u6163\u3092\u8eab\u306b\u3064\u3051\u3066\u304f\u3060\u3055\u3044\u3002\"\n      }\n    }\n  ]\n}\n<\/script>\n\n\n\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SSMS\u306f\u7121\u6599\u3067\u4f7f\u3048\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SSMS\uff08SQL Server Management Studio\uff09\u672c\u4f53\u306f\u5e38\u306b\u7121\u511f\u3067\u63d0\u4f9b\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u305f\u3060\u3057\u63a5\u7d9a\u5148\u306eSQL Server\u306b\u306f\u6709\u511f\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u3082\u3042\u308a\u307e\u3059\u3002\u958b\u767a\u30fb\u5b66\u7fd2\u7528\u9014\u3067\u3042\u308c\u3070SQL Server Developer Edition\uff08\u672c\u756a\u5229\u7528\u4ee5\u5916\u306f\u7121\u511f\uff09\u307e\u305f\u306fSQL Server Express\uff08\u6a5f\u80fd\u5236\u9650\u3042\u308a\u30fb\u672c\u756a\u5229\u7528\u53ef\u80fd\uff09\u3092\u7121\u511f\u3067\u4f7f\u3048\u307e\u3059\u3002\u8cbb\u7528\u3092\u30bc\u30ed\u3067\u59cb\u3081\u305f\u3044\u5834\u5408\u306f\u300cSQL Server Developer + SSMS\u6700\u65b0\u7248\u300d\u306e\u7d44\u307f\u5408\u308f\u305b\u304c\u6700\u3082\u6a5f\u80fd\u7684\u3067\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SSMS\u306fMac\u3067\u3082\u4f7f\u3048\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SSMS\u306fWindows\u5c02\u7528\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u306e\u305f\u3081\u3001macOS\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u3002macOS\u3067SQL Server\u3092\u7ba1\u7406\u3057\u305f\u3044\u5834\u5408\u306f\u3001Microsoft\u304c\u63d0\u4f9b\u3059\u308b\u300cAzure Data Studio\u300d\u3092\u4f7f\u3063\u3066\u304f\u3060\u3055\u3044\u3002Azure Data Studio\u306fmacOS\u30fbLinux\u30fbWindows\u306b\u5bfe\u5fdc\u3057\u3066\u304a\u308a\u3001\u57fa\u672c\u7684\u306a\u30af\u30a8\u30ea\u5b9f\u884c\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057SSMS\u3068\u6bd4\u3079\u308b\u3068\u7ba1\u7406\u6a5f\u80fd\u306f\u9650\u5b9a\u7684\u3067\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SSMS\u3068SQL Server\u3001\u3069\u3061\u3089\u3092\u5148\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308c\u3070\u3044\u3044\u3067\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SQL Server\u3092\u5148\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u305d\u306e\u5f8cSSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002SQL Server\u306fSSMS\u304c\u63a5\u7d9a\u3059\u308b\u5bfe\u8c61\uff08\u30b5\u30fc\u30d0\u30fc\uff09\u306a\u306e\u3067\u3001\u63a5\u7d9a\u5148\u304c\u5b58\u5728\u3057\u306a\u3044\u72b6\u614b\u3067SSMS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3082\u610f\u5473\u304c\u306a\u3044\u305f\u3081\u3067\u3059\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u9806\u5e8f\uff1a\u2460 SQL Server Developer\/Express \u2192 \u2461 SSMS \u2192 \u2462 SSMS\u3092\u8d77\u52d5\u3057\u3066\u63a5\u7d9a\u78ba\u8a8d\u3001\u3068\u3044\u3046\u6d41\u308c\u304c\u6b63\u3057\u3044\u624b\u9806\u3067\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"SELECT * FROM \u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5b9f\u884c\u3057\u305f\u3089\u5927\u91cf\u30c7\u30fc\u30bf\u304c\u8fd4\u3063\u3066\u304d\u3066\u30d5\u30ea\u30fc\u30ba\u3057\u307e\u3057\u305f\u3002\u3069\u3046\u3059\u308c\u3070\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"SELECT * FROM \u30c6\u30fc\u30d6\u30eb\u540d \u306f\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u3092\u8fd4\u3059\u305f\u3081\u3001\u6570\u767e\u4e07\u4ef6\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5b9f\u884c\u3059\u308b\u3068SSMS\u304c\u30d5\u30ea\u30fc\u30ba\u3059\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u672c\u756aDB\u3067\u306f\u5e38\u306bSELECT TOP 100 * FROM \u30c6\u30fc\u30d6\u30eb\u540d \u306e\u3088\u3046\u306bTOP\u3067\u4ef6\u6570\u3092\u5236\u9650\u3059\u308b\u304b\u3001WHERE\u53e5\u3067\u7d5e\u308a\u8fbc\u3093\u3067\u304b\u3089\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30d5\u30ea\u30fc\u30ba\u4e2d\u306fSSMS\u306e\u30c4\u30fc\u30eb\u30d0\u30fc\u306e\u8d64\u3044\u300c\u505c\u6b62\u300d\u30dc\u30bf\u30f3\uff08\u307e\u305f\u306fAlt+Break\uff09\u3067\u30af\u30a8\u30ea\u3092\u4e2d\u65ad\u3067\u304d\u307e\u3059\u3002\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"WHERE\u53e5\u3092\u66f8\u304d\u5fd8\u308c\u3066UPDATE\u3092\u5b9f\u884c\u3057\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002\u53d6\u308a\u6d88\u305b\u307e\u3059\u304b\uff1f\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\uff08BEGIN TRAN\uff09\u3092\u4f7f\u3063\u3066\u5b9f\u884c\u3057\u3066\u3044\u305f\u5834\u5408\u306f\u3001ROLLBACK TRAN\u3067\u53d6\u308a\u6d88\u305b\u307e\u3059\u3002\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306a\u3057\u3067\u5b9f\u884c\u3057\u3066\u3057\u307e\u3063\u305f\u5834\u5408\u306f\u3001\u539f\u5247\u3068\u3057\u3066\u53d6\u308a\u6d88\u305b\u307e\u305b\u3093\u3002\u305f\u3060\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304c\u5b58\u5728\u3059\u308c\u3070\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304b\u3089\u306e\u5fa9\u5143\u304c\u53ef\u80fd\u3067\u3059\u3002\u672c\u756aDB\u3067\u306f\u5b9a\u671f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u8a2d\u5b9a\u304c\u5fc5\u9808\u3067\u3042\u308b\u7406\u7531\u304c\u3053\u3053\u306b\u3042\u308a\u307e\u3059\u3002\u4eca\u5f8c\u306fUPDATE\u30fbDELETE\u524d\u306b\u5fc5\u305a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u7fd2\u6163\u3092\u8eab\u306b\u3064\u3051\u3066\u304f\u3060\u3055\u3044\u3002\"\n      }\n    }\n  ]\n}\n<\/script>\n\n\n\n<p style=\"font-size:16px;line-height:1.8;color:#e0e0e0;margin:0 0 20px;\">\nSQL\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7406\u89e3\u304c\u6df1\u307e\u308b\u3068\u3001\u300c\u696d\u52d9\u30c7\u30fc\u30bf\u3092\u3082\u3063\u3068\u6d3b\u304b\u3057\u305f\u3044\u300d\u300c\u30b7\u30b9\u30c6\u30e0\u9593\u306e\u30c7\u30fc\u30bf\u9023\u643a\u3092\u81ea\u52d5\u5316\u3057\u305f\u3044\u300d\u3068\u3044\u3046\u8ab2\u984c\u304c\u898b\u3048\u3066\u304d\u307e\u3059\u3002<br><br>\n\u5f0a\u793e\uff08\u682a\u5f0f\u4f1a\u793eGENAI\uff09\u3067\u306f\u3001SQL Server\u3084MySQL\u306e\u30c7\u30fc\u30bf\u3092\u6d3b\u7528\u3057\u305f<strong>\u696d\u52d9\u81ea\u52d5\u5316\u30fbAI\u9023\u643a\u306e\u8a2d\u8a08\u30fb\u69cb\u7bc9<\/strong>\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002CRM\u306e\u30c7\u30fc\u30bf\u5206\u6790\u3001\u7d4c\u7406\u30c7\u30fc\u30bf\u306e\u81ea\u52d5\u96c6\u8a08\u3001Web\u30b7\u30b9\u30c6\u30e0\u3068\u306e\u30c7\u30fc\u30bf\u9023\u643a\u306a\u3069\u3001\u300c\u30c7\u30fc\u30bf\u306f\u3042\u308b\u306e\u306b\u6d3b\u304b\u305b\u3066\u3044\u306a\u3044\u300d\u3068\u3044\u3046\u72b6\u6cc1\u3092\u89e3\u6c7a\u3057\u307e\u3059\u3002<br><br>\n\u307e\u305a\u306f\u7121\u6599\u76f8\u8ac7\u3067\u3001\u5fa1\u793e\u306e\u8ab2\u984c\u3092\u304a\u805e\u304b\u305b\u304f\u3060\u3055\u3044\u3002\n<\/p>\n\n<div style=\"background:linear-gradient(135deg,#1a1a1a 0%,#2a1015 100%);border-radius:16px;padding:36px 32px;margin:48px 0 16px;color:#fff;\">\n  <p style=\"font-size:13px;font-weight:700;color:#dc2626;letter-spacing:2px;margin:0 0 12px;\">NEXT STEP<\/p>\n  <p style=\"font-size:22px;font-weight:800;line-height:1.5;margin:0 0 20px;\">\u3053\u306e\u8a18\u4e8b\u306e\u5185\u5bb9\u3092\u3001\u3042\u306a\u305f\u306e\u30d3\u30b8\u30cd\u30b9\u3067<br>\u5b9f\u8df5\u3057\u3066\u307f\u307e\u305b\u3093\u304b\uff1f<\/p>\n  <div style=\"background:rgba(255,255,255,0.06);border:1px solid rgba(255,255,255,0.12);border-radius:12px;padding:24px;max-width:560px;margin:0 auto;\">\n    <p style=\"font-size:13px;color:#dc2626;font-weight:700;margin:0 0 8px;\">AI\u6d3b\u7528\u3092\u81ea\u793e\u3067\u56de\u305b\u308b\u3088\u3046\u306b\u306a\u308a\u305f\u3044\u65b9\u3078<\/p>\n    <p style=\"font-size:20px;font-weight:800;margin:0 0 12px;\">AI\u9b3c\u7ba1\u7406<\/p>\n    <p style=\"font-size:14px;color:rgba(255,255,255,0.75);margin:0 0 20px;line-height:1.7;\">Claude Code\u30fbCowork\u5c0e\u5165\u652f\u63f4\u304b\u3089\u696d\u52d9\u8a2d\u8a08\u30fb\u793e\u5185\u6d78\u900f\u307e\u3067\u5b9f\u8df5\u30d9\u30fc\u30b9\u3067\u4f34\u8d70\u3002\u300c\u81ea\u793e\u3067\u56de\u305b\u308b\u7d44\u7e54\u300d\u309290\u65e5\u3067\u4f5c\u308b\u7d4c\u55b6\u8005\u5411\u3051\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u3002<\/p>\n    <div style=\"text-align:center;\">\n      <a href=\"https:\/\/aikanri.genai-ai.co.jp\/?utm_source=blog&utm_medium=article&utm_campaign=cc-ssms-guide&utm_content=next-step-cta\" target=\"_blank\" rel=\"noopener\" style=\"display:inline-block;background:#dc2626;color:#fff;font-weight:700;font-size:15px;padding:14px 32px;border-radius:30px;text-decoration:none;\">AI\u9b3c\u7ba1\u7406\u3092\u8a73\u3057\u304f\u898b\u308b \u2192<\/a>\n    <\/div>\n  <\/div>\n<\/div>\n\n\n","protected":false},"excerpt":{"rendered":"<p>SQL Server Management Studio\uff08SSMS\uff09\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089\u57fa\u672c\u64cd\u4f5c\u307e\u3067\u5b8c\u5168\u89e3\u8aac\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30fb\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u3001SELECT\u30fbINSERT\u30fbUPDATE\u30fbDELETE\u6587\u306e\u5b9f\u884c\u65b9\u6cd5\u3001\u30af\u30a8\u30ea\u81ea\u52d5\u4f5c\u6210\u6a5f\u80fd\u307e\u3067\u521d\u5fc3\u8005\u5411\u3051\u306b\u4e01\u5be7\u306b\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"sitemap_hide":"","_veu_custom_css":"","vkexunit_cta_each_option":"","footnotes":"","rank_math_description":"SQL Server Management Studio\uff08SSMS\uff09\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089\u57fa\u672c\u64cd\u4f5c\u307e\u3067\u5b8c\u5168\u89e3\u8aac\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30fb\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u3001SELECT\u30fbINSERT\u30fbUPDATE\u30fbDELETE\u6587\u306e\u5b9f\u884c\u65b9\u6cd5\u3001\u30af\u30a8\u30ea\u81ea\u52d5\u4f5c\u6210\u6a5f\u80fd\u307e\u3067\u521d\u5fc3\u8005\u5411\u3051\u306b\u4e01\u5be7\u306b\u8aac\u660e\u3057\u307e\u3059\u3002","rank_math_focus_keyword":"SQL Server Management Studio","rank_math_title":"\u30102026\u5e747\u6708\u6700\u65b0\u3011SQL Server Management Studio(SSMS)\u306e\u4f7f\u3044\u65b9\u5b8c\u5168\u30ac\u30a4\u30c9\uff5c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089SQL\u5b9f\u884c\u307e\u3067\u521d\u5fc3\u8005\u5411\u3051\u306b\u89e3\u8aac","pending_rewrite_html":"","pending_rewrite_id":"","pending_rewrite_kw":"","pending_rewrite_at":"","pending_rewrite_source":"","pending_rewrite_brief":"","pending_rewrite_evidence":"","approved_rewrite_html":"","approved_rewrite_id":"","approved_rewrite_kw":"","approved_rewrite_at":"","approved_rewrite_by":"","approved_rewrite_brief":"","approved_rewrite_evidence":"","rewrite_tracker_baseline":"","rewrite_tracker_7day":"","rewrite_tracker_14day":"","rewrite_tracker_30day":"","rewrite_tracker_notified":""},"categories":[2],"tags":[],"class_list":["post-18380","post","type-post","status-publish","format-standard","hentry","category-claude-tips"],"_links":{"self":[{"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/posts\/18380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/comments?post=18380"}],"version-history":[{"count":1,"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/posts\/18380\/revisions"}],"predecessor-version":[{"id":18381,"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/posts\/18380\/revisions\/18381"}],"wp:attachment":[{"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/media?parent=18380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/categories?post=18380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/genai-ai.co.jp\/ai-kanri\/wp-json\/wp\/v2\/tags?post=18380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}