{"id":6754,"date":"2026-07-12T02:06:37","date_gmt":"2026-07-12T10:06:37","guid":{"rendered":"https:\/\/www.gudusoft.com\/sql-server-data-lineage\/"},"modified":"2026-07-12T02:06:37","modified_gmt":"2026-07-12T10:06:37","slug":"sql-server-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/jp\/sql-server%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%aa%e3%83%8d%e3%83%bc%e3%82%b8\/","title":{"rendered":"SQL Server\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\uff1aT-SQL\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3001\u304a\u3088\u3073\u52d5\u7684SQL"},"content":{"rendered":"<p><strong>SQL Server\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8<\/strong> \u3053\u308c\u306f\u3001\u30c7\u30fc\u30bf\u304c T-SQL \u30b3\u30fc\u30c9\u5185\u3092\u3069\u306e\u3088\u3046\u306b\u79fb\u52d5\u3059\u308b\u304b\u3092\u793a\u3059\u5217\u30ec\u30d9\u30eb\u306e\u30de\u30c3\u30d7\u3067\u3059\u3002\u3069\u306e\u30bd\u30fc\u30b9\u5217\u304c\u5404\u30bf\u30fc\u30b2\u30c3\u30c8 \u30c6\u30fc\u30d6\u30eb\u3001\u30d3\u30e5\u30fc\u3001\u307e\u305f\u306f\u30ec\u30dd\u30fc\u30c8\u306b\u4f9b\u7d66\u3055\u308c\u3001\u305d\u306e\u904e\u7a0b\u3067\u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3001 <code>\u30de\u30fc\u30b8<\/code> \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3001\u304a\u3088\u3073\u52d5\u7684SQL\u3002 <a href=\"https:\/\/www.gudusoft.com\/jp\/sql-data-lineage-tool\/\">Gudu SQLFlow<\/a> \u5c02\u7528\u306e SQL Server \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30eb \u30d1\u30fc\u30b5\u30fc\u3092\u4f7f\u7528\u3057\u3066 T-SQL \u3092\u89e3\u6790\u3059\u308b\u3053\u3068\u3067\u3001\u305d\u306e\u30de\u30c3\u30d7\u3092\u81ea\u52d5\u7684\u306b\u69cb\u7bc9\u3059\u308b\u305f\u3081\u3001SSMS \u306e\u4f9d\u5b58\u95a2\u4fc2\u30d3\u30e5\u30fc\u306e\u3088\u3046\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8 \u30ec\u30d9\u30eb\u3067\u5c65\u6b74\u304c\u9014\u5207\u308c\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#eef7fb;padding-top:24px;padding-bottom:24px\"><div class=\"wp-block-group__inner-container\">\n\n<p><strong>\u4eca\u3059\u3050\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\uff1a<\/strong> T-SQL \u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u8cbc\u308a\u4ed8\u3051\u307e\u3059 <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=sql-server-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">\u7121\u6599\u306eSQL Server\u7cfb\u7d71\u56f3\u4f5c\u6210\u30c4\u30fc\u30eb<\/a> \u305d\u3057\u3066\u3001\u6570\u79d2\u3067\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\u56f3\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server\u306e\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u304c\u898b\u305f\u76ee\u3088\u308a\u96e3\u3057\u3044\u7406\u7531<\/h2>\n\n\n\n<p>\u307b\u3068\u3093\u3069\u306e SQL Server \u74b0\u5883\u3067\u306f\u3001\u5b9f\u969b\u306b\u91cd\u8981\u306a\u5909\u63db\u30ed\u30b8\u30c3\u30af\u306f\u6574\u7136\u3068\u3057\u305f\u30d3\u30e5\u30fc\u306b\u306f\u5b58\u5728\u3057\u307e\u305b\u3093\u3002\u305d\u308c\u306f\u30c7\u30fc\u30bf\u3092\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u3059\u308b\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306b\u5b58\u5728\u3057\u307e\u3059\u3002 <code>#temp<\/code> \u30c6\u30fc\u30d6\u30eb\u3001\u30d5\u30a1\u30af\u30c8\u30c6\u30fc\u30d6\u30eb\u306b\u30a2\u30c3\u30d7\u30b5\u30fc\u30c8 <code>\u30de\u30fc\u30b8<\/code>\u30d1\u30e9\u30e1\u30fc\u30bf\u306b\u57fa\u3065\u3044\u3066\u5206\u5c90\u3057\u3001\u5b9f\u884c\u6642\u306b SQL \u6587\u5b57\u5217\u3092\u7d44\u307f\u7acb\u3066\u307e\u3059\u3002 <code>sp_executesql<\/code> \u307e\u305f <code>\u30a8\u30b0\u30bc\u30af\u30c6\u30a3\u30d6<\/code>\u30ab\u30bf\u30ed\u30b0\u304b\u3089\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u5b9a\u7fa9\u3092\u8aad\u307f\u53d6\u308b\u3060\u3051\u306e\u7cfb\u7d71\u8ffd\u8de1\u30a2\u30d7\u30ed\u30fc\u30c1\u3067\u306f\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306f\u30d6\u30e9\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u5b58\u5728\u3059\u308b\u3053\u3068\u306f\u308f\u304b\u308a\u307e\u3059\u304c\u3001\u3069\u306e\u5217\u304c\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u901a\u904e\u3059\u308b\u304b\u306f\u308f\u304b\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u30b3\u30fc\u30c9\u304b\u3089\u771f\u306e\u5c65\u6b74\u60c5\u5831\u3092\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u3068\u540c\u3058\u3088\u3046\u306bT-SQL\u3092\u89e3\u6790\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3064\u307e\u308a\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u672c\u4f53\u5185\u306e\u3059\u3079\u3066\u306e\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u30bb\u30de\u30f3\u30c6\u30a3\u30c3\u30af\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9\u3057\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3084\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u3092\u901a\u904e\u3059\u308b\u5217\u3092\u8ffd\u8de1\u3057\u3001\u6587\u5b57\u5217\u5909\u6570\u306e\u4e2d\u306b\u96a0\u3055\u308c\u305fSQL\u3092\u89e3\u6c7a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f\u30b3\u30f3\u30d1\u30a4\u30e9\u306e\u554f\u984c\u3067\u3042\u308a\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u30af\u30a8\u30ea\u306e\u554f\u984c\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u305d\u3057\u3066\u3001\u307e\u3055\u306bSQLFlow\u306eT-SQL\u30d1\u30fc\u30b5\u30fc\u306f\u3001\u3053\u306e\u76ee\u7684\u306e\u305f\u3081\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SSMS\u306e\u4f9d\u5b58\u95a2\u4fc2\u30d3\u30e5\u30fc\u3067\u308f\u304b\u308b\u3053\u3068\u3068\u308f\u304b\u3089\u306a\u3044\u3053\u3068<\/h2>\n\n\n\n<p>SQL Server\u306b\u306f\u4fbf\u5229\u306a\u4f9d\u5b58\u95a2\u4fc2\u30c4\u30fc\u30eb\u304c\u4ed8\u5c5e\u3057\u3066\u304a\u308a\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30ec\u30d9\u30eb\u306e\u7c21\u5358\u306a\u8cea\u554f\u306b\u5bfe\u3059\u308b\u6700\u521d\u306e\u7a93\u53e3\u3068\u3057\u3066\u6700\u9069\u3067\u3059\u3002 <code>sys.sql_expression_dependencies<\/code>, <code>sys.dm_sql_referenced_entities<\/code>SSMS \u306e\u300c\u4f9d\u5b58\u95a2\u4fc2\u306e\u8868\u793a\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u3067\u306f\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3 A \u304c\u30c6\u30fc\u30d6\u30eb B \u3092\u53c2\u7167\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u5b9f\u306b\u308f\u304b\u308a\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u6b21\u306e\u3053\u3068\u306f\u308f\u304b\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<ul><li><strong>\u5217\u30ec\u30d9\u30eb\u306e\u30d5\u30ed\u30fc\u3002<\/strong> \u30ab\u30bf\u30ed\u30b0\u306e\u4f9d\u5b58\u95a2\u4fc2\u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30ec\u30d9\u30eb\u3067\u6b62\u307e\u308a\u307e\u3059\u3002 <code>usp_load_fact_sales<\/code> \u30bf\u30c3\u30c1 <code>\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u8ca9\u58f2<\/code> \u3068 <code>dw.fact_sales<\/code>\u3057\u304b\u3057\u3001\u305d\u308c\u306f\u9055\u3046 <code>\u4e8b\u5b9f\u58f2\u4e0a\u91d1\u984d<\/code> \u304b\u3089\u6d3e\u751f\u3059\u308b <code>\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u8ca9\u58f2\u91d1\u984d<\/code> \u3092\u901a\u3058\u3066 <code>\u30ad\u30e3\u30b9\u30c8<\/code> \u305d\u306e\u9593 <code>\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0.\u30bb\u30fc\u30eb\u30b9.\u30ed\u30fc\u30c9_\u65e5\u4ed8<\/code> \u884c\u306e\u307f\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u307e\u3059\u3002<\/li>\n<li><strong>\u6d41\u308c\u306e\u65b9\u5411\u3002<\/strong> \u53c2\u7167\u306f\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u8aad\u307f\u53d6\u3063\u305f\u30c7\u30fc\u30bf\u3068\u30c6\u30fc\u30d6\u30eb\u306b\u66f8\u304d\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u306f\u540c\u3058\u4f9d\u5b58\u95a2\u4fc2\u306e\u884c\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u306f\u3001\u3069\u3061\u3089\u304c\u30bd\u30fc\u30b9\u3067\u3069\u3061\u3089\u304c\u30bf\u30fc\u30b2\u30c3\u30c8\u304b\u3092\u8a8d\u8b58\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/li>\n<li><strong>\u52d5\u7684SQL\u3002<\/strong> \u6587\u5b57\u5217\u5185\u306b\u69cb\u7bc9\u3055\u308c\u3001\u5b9f\u884c\u3055\u308c\u308b\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8 <code>sp_executesql<\/code> \u307e\u305f <code>\u30a8\u30b0\u30bc\u30af\u30c6\u30a3\u30d6<\/code> \u3053\u308c\u3089\u306f\u5b9f\u884c\u6642\u307e\u3067\u5b58\u5728\u3057\u306a\u3044\u305f\u3081\u3001\u4f9d\u5b58\u95a2\u4fc2\u30ab\u30bf\u30ed\u30b0\u304b\u3089\u306f\u5168\u304f\u898b\u3048\u307e\u305b\u3093\u3002<\/li>\n<li><strong>\u4e00\u6642\u7684\u306a\u30c6\u30fc\u30d6\u30eb\u30db\u30c3\u30d7\u3002<\/strong> <code>#temp<\/code> \u30c6\u30fc\u30d6\u30eb\u306f <code>tempdb<\/code> \u307e\u305f\u3001\u4f9d\u5b58\u95a2\u4fc2\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3068\u3057\u3066\u8ffd\u8de1\u3055\u308c\u306a\u3044\u305f\u3081\u3001\u305d\u308c\u3089\u3092\u901a\u904e\u3059\u308b\u7cfb\u7d71\u306f\u3059\u3079\u3066\u534a\u5206\u306b\u5207\u65ad\u3055\u308c\u307e\u3059\u3002<\/li><\/ul>\n\n\n\n<p>\u300c\u3053\u306e\u5217\u3092\u518d\u5165\u529b\u3059\u308b\u3068\u4e0b\u6d41\u3067\u4f55\u304c\u58ca\u308c\u308b\u306e\u304b\u300d\u3084\u300c\u3069\u306e\u30bd\u30fc\u30b9\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u3053\u306e\u898f\u5236\u5bfe\u8c61\u30ec\u30dd\u30fc\u30c8\u306b\u30c7\u30fc\u30bf\u3092\u63d0\u4f9b\u3057\u3066\u3044\u308b\u306e\u304b\u300d\u3068\u3044\u3063\u305f\u7591\u554f\u306b\u7b54\u3048\u308b\u306b\u306f\u3001T-SQL\u672c\u4f53\u81ea\u4f53\u3092\u89e3\u6790\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30ab\u30bf\u30ed\u30b0\u304c\u65e2\u306b\u63d0\u4f9b\u3057\u3066\u3044\u308b\u6a5f\u80fd\u306e\u4e0a\u306bSQLFlow\u304c\u8ffd\u52a0\u3059\u308b\u30ec\u30a4\u30e4\u30fc\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\u304cT-SQL\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u7cfb\u7d71\u3092\u8ffd\u8de1\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n<p>SQLFlow\u306f\u3001 <a href=\"https:\/\/www.sqlparser.com\/\">\u6c4e\u7528SQL\u30d1\u30fc\u30b5\u30fc\uff08GSP\uff09<\/a>, a commercial SQL compiler front-end developed since the mid-2000s and validated against roughly 13,600 per-dialect SQL test fixtures. Its SQL Server support is a dedicated T-SQL grammar, not a generic ANSI parser with exceptions bolted on, and it includes a full procedural parser for stored procedure bodies. Inside a procedure, SQLFlow resolves:<\/p>\n\n\n\n<ul><li><strong>\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3068\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u3002<\/strong> \u5217\u306f\u4ee5\u4e0b\u3092\u901a\u3058\u3066\u8ffd\u8de1\u3055\u308c\u307e\u3059 <code>SELECT ... INTO #staging<\/code>, <code>INSERT INTO @rows<\/code>\u3001\u305d\u3057\u3066\u305d\u306e\u5f8c\u306e\u3059\u3079\u3066\u306e\u8aad\u307f\u53d6\u308a\u3001\u3057\u305f\u304c\u3063\u3066 3 \u30db\u30c3\u30d7\u306e\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3 <code>tempdb<\/code> \u4e00\u3064\u306e\u9023\u7d9a\u3057\u305f\u7cfb\u7d71\u306e\u7d4c\u8def\u3068\u3057\u3066\u73fe\u308c\u308b\u3002<\/li>\n<li><strong><code>\u30de\u30fc\u30b8<\/code> \u58f0\u660e\u3002<\/strong> \u305d\u308c\u305e\u308c <code>\u4e00\u81f4\u3057\u305f\u3089\u66f4\u65b0\u3059\u308b<\/code> \u3068 <code>\u4e00\u81f4\u3057\u306a\u3044\u5834\u5408\u306f\u633f\u5165\u3059\u308b<\/code> \u30d6\u30e9\u30f3\u30c1\u304c\u5206\u6790\u3055\u308c\u3001\u30bd\u30fc\u30b9\u5217\u304c\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u3055\u308c\u3001 <code>\u306e\u4e0a<\/code> \u9593\u63a5\u7684\u306a\u8840\u7d71\u3068\u3057\u3066\u306e\u72b6\u614b\u3002<\/li>\n<li><strong>\u52d5\u7684SQL\u3002<\/strong> SQL\u306f\u5909\u6570\u306b\u7d44\u307f\u7acb\u3066\u3089\u308c\u3001 <code>sp_executesql<\/code> \u307e\u305f <code>\u30a8\u30b0\u30bc\u30af\u30c6\u30a3\u30d6<\/code> \u30b9\u30ad\u30c3\u30d7\u3055\u308c\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u89e3\u6c7a\u3055\u308c\u3066\u89e3\u6790\u3055\u308c\u308b\u3002\u3053\u308c\u306f\u3001\u7cfb\u7d71\u8ffd\u8de1\u30c4\u30fc\u30eb\u306b\u304a\u3051\u308b\u6700\u3082\u4e00\u822c\u7684\u306a\u76f2\u70b9\u306e1\u3064\u3067\u3042\u308b\u3002<\/li>\n<li><strong>\u624b\u9806\u30d1\u30e9\u30e1\u30fc\u30bf\u3002<\/strong> \u7cfb\u7d71\u306f\u30d1\u30e9\u30e1\u30fc\u30bf\u5024\u3092\u901a\u3057\u3066\u3001\u305d\u308c\u3089\u3092\u4f7f\u7528\u3059\u308b\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3078\u3068\u6d41\u308c\u307e\u3059\u3002<\/li>\n<li><strong>\u901a\u8a71\u30b0\u30e9\u30d5\u3002<\/strong> \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u4ed6\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u547c\u3073\u51fa\u3059\u5834\u5408\u3001SQLFlow \u306f\u5bfe\u8a71\u578b\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u9593\u547c\u3073\u51fa\u3057\u30b0\u30e9\u30d5\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u3001\u500b\u3005\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3060\u3051\u3067\u306a\u304f\u3001ETL \u30c1\u30a7\u30fc\u30f3\u5168\u4f53\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b9f\u4f8b\uff1aMERGE\u306b\u3088\u308b\u30d5\u30a1\u30af\u30c8\u30c6\u30fc\u30d6\u30eb\u3078\u306e\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0<\/h2>\n\n\n\n<p>SQL Server\u306e\u30c7\u30fc\u30bf\u30a6\u30a7\u30a2\u30cf\u30a6\u30b9\u306b\u306f\u5fc5\u305a\u3053\u306e\u3088\u3046\u306a\u624b\u9806\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u884c\u3092\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u30af\u30ea\u30fc\u30f3\u30a2\u30c3\u30d7\u3057\u3001\u305d\u306e\u5f8c\u30d5\u30a1\u30af\u30c8\u30c6\u30fc\u30d6\u30eb\u306b\u30de\u30fc\u30b8\u3059\u308b\u30ed\u30fc\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PROCEDURE dbo.usp_load_fact_sales AS BEGIN SELECT s.order_id, s.customer_id, CAST(s.amount AS DECIMAL(18,2)) AS amount INTO #clean_sales FROM staging.sales s WHERE s.load_date = CAST(GETDATE() AS DATE); MERGE dw.fact_sales AS tgt USING #clean_sales AS src ON tgt.order_id = src.order_id WHEN MATCHED THEN UPDATE SET tgt.amount = src.amount WHEN NOT MATCHED THEN INSERT (order_id, customer_id, amount) VALUES (src.order_id, src.customer_id, src.amount); END<\/code><\/pre>\n\n\n\n<p>\u3053\u308c\u3092SQLFlow\u3067\u5b9f\u884c\u3059\u308b\u3068\u3001\u56f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059 <code>dw.fact_sales.amount<\/code> \u4f9b\u7d66 <code>\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u8ca9\u58f2\u91d1\u984d<\/code> \u3092\u901a\u3058\u3066 <code>\u30ad\u30e3\u30b9\u30c8<\/code>\u3001 \u3068 <code>#clean_sales<\/code> \u4e2d\u9593\u30db\u30c3\u30d7\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u307e\u305f\u3001\u30ab\u30bf\u30ed\u30b0\u30af\u30a8\u30ea\u3067\u306f\u6c7a\u3057\u3066\u751f\u6210\u3067\u304d\u306a\u30442\u3064\u306e\u95a2\u4fc2\u3082\u793a\u3057\u3066\u3044\u307e\u3059\u3002 <code>\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0.\u30bb\u30fc\u30eb\u30b9.\u30ed\u30fc\u30c9_\u65e5\u4ed8<\/code> \u3059\u3079\u3066\u306e\u51fa\u529b\u5217\u3078\u306e\u9593\u63a5\u7684\u306a\u7cfb\u7d71\u3068\u3057\u3066\uff08\u3069\u306e\u884c\u3092\u30ed\u30fc\u30c9\u3059\u308b\u304b\u3092\u6c7a\u5b9a\u3057\u307e\u3059\uff09\u3001 <code>\u6ce8\u6587ID<\/code> \u4e8c\u91cd\u306e\u5f79\u5272\u3092\u679c\u305f\u3057\u307e\u3059 - \u633f\u5165\u3055\u308c\u305f\u30ad\u30fc\u3078\u306e\u76f4\u63a5\u7684\u306a\u7cfb\u8b5c\u3068\u3001 <code>\u30de\u30fc\u30b8...\u30aa\u30f3<\/code> \u30de\u30c3\u30c1\u6761\u4ef6\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">T-SQL\u306b\u304a\u3051\u308b\u76f4\u63a5\u7684\u306a\u7cfb\u8b5c\u3068\u9593\u63a5\u7684\u306a\u7cfb\u8b5c<\/h2>\n\n\n\n<p>SQLFlow\u306f\u533a\u5225\u3057\u307e\u3059 <strong>\u76f4\u7cfb\u306e\u8840\u7d71<\/strong> \uff08\u30bd\u30fc\u30b9\u5217\u306e\u5024\u304c\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u306b\u683c\u7d0d\u3055\u308c\u308b\uff09 <strong>\u9593\u63a5\u7684\u306a\u7cfb\u7d71<\/strong> \uff08\u5217\u306f\u3001 <code>\u3069\u3053<\/code> \u53e5\u3001 <code>\u53c2\u52a0\u3059\u308b<\/code> \u307e\u305f <code>\u30de\u30fc\u30b8\u30aa\u30f3<\/code> \u72b6\u614b\u3001 <code>\u30b0\u30eb\u30fc\u30d7\u5206\u3051<\/code>\u3001\u307e\u305f\u306f\u96c6\u8a08\uff09\u3002\u3053\u306e2\u3064\u306f\u56f3\u3067\u500b\u5225\u306b\u5207\u308a\u66ff\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30ed\u30fc\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306b\u306f\u30d0\u30c3\u30c1\u65e5\u4ed8\u3001\u30b9\u30c6\u30fc\u30bf\u30b9\u30d5\u30e9\u30b0\u3001\u30a6\u30a9\u30fc\u30bf\u30fc\u30de\u30fc\u30af\u5217\u306a\u3069\u3001\u51fa\u529b\u306b\u306f\u8868\u793a\u3055\u308c\u306a\u3044\u3082\u306e\u306e\u5230\u7740\u3059\u308b\u30c7\u30fc\u30bf\u3092\u6697\u9ed9\u7684\u306b\u5236\u5fa1\u3059\u308b\u30d5\u30a3\u30eb\u30bf\u5217\u304c\u591a\u6570\u3042\u308b\u305f\u3081\u3001T-SQL \u4f5c\u696d\u3067\u306f\u4ed6\u306e\u307b\u3068\u3093\u3069\u306e\u65b9\u8a00\u3088\u308a\u3082\u91cd\u8981\u306b\u306a\u308a\u307e\u3059\u3002\u307b\u3068\u3093\u3069\u306e\u30ea\u30cd\u30fc\u30b8\u30c4\u30fc\u30eb\u306f\u3053\u306e\u533a\u5225\u3092\u307e\u3063\u305f\u304f\u30e2\u30c7\u30eb\u5316\u3057\u3066\u3044\u307e\u305b\u3093\u3002\u30ed\u30fc\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u5f71\u97ff\u5206\u6790\u3067\u306f\u3001\u591a\u304f\u306e\u5834\u5408\u3001\u554f\u984c\u3068\u306a\u308b\u306e\u306f\u5f8c\u8005\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server\u306e\u7cfb\u7d71\u60c5\u5831\u306e\u53d6\u5f97\uff1a\u5165\u529b\u3068\u5c55\u958b<\/h2>\n\n\n\n<p>SQL Server \u30b3\u30fc\u30c9\u3092 SQLFlow \u306b\u6e21\u3059\u65b9\u6cd5\u306f\u3001\u74b0\u5883\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30ec\u30d9\u30eb\u306b\u5fdc\u3058\u3066\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u5165\u529b<\/th><th>\u4ed5\u7d44\u307f<\/th><th>\u826f\u3044<\/th><\/tr><\/thead><tbody>\n<tr><td>T-SQL\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u304b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044<\/td><td>\u30b9\u30af\u30ea\u30d7\u30c8\u3001DDL\u3001\u304a\u3088\u3073\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5b9a\u7fa9\u3092\u30d5\u30a1\u30a4\u30eb\u307e\u305f\u306f\u8cbc\u308a\u4ed8\u3051\u305f\u30c6\u30ad\u30b9\u30c8\u3068\u3057\u3066<\/td><td>\u8fc5\u901f\u306a\u5206\u6790\u3001\u30b3\u30fc\u30c9\u30ec\u30d3\u30e5\u30fc\u3001\u4e00\u5ea6\u306b1\u3064\u306e\u624b\u9806<\/td><\/tr>\n<tr><td>JDBC\u7d4c\u7531\u306e\u30e9\u30a4\u30d6\u30e1\u30bf\u30c7\u30fc\u30bf<\/td><td>SQLFlow\u306f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304b\u3089DDL\u3001\u30d3\u30e5\u30fc\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5b9a\u7fa9\u3092\u53d6\u5f97\u3057\u307e\u3059<\/td><td>\u5e38\u306b\u6700\u65b0\u306e\u72b6\u614b\u306b\u4fdd\u305f\u308c\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5168\u4f53\u306e\u7cfb\u7d71\u60c5\u5831<\/td><\/tr>\n<tr><td>Grabit\u30e1\u30bf\u30c7\u30fc\u30bf\u62bd\u51fa<\/td><td>\u30aa\u30d5\u30e9\u30a4\u30f3\u62bd\u51fa\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u306f\u30e1\u30bf\u30c7\u30fc\u30bf\u3092SQLFlow\u306b\u9001\u4fe1\u3057\u307e\u3059<\/td><td>Lineage\u30b5\u30fc\u30d0\u30fc\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u74b0\u5883<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\u3044\u305a\u308c\u306e\u5834\u5408\u3082\u5206\u6790\u306f\u9759\u7684\u3067\u3059\u3002SQLFlow \u306f SQL \u30b3\u30fc\u30c9\u3068\u30b9\u30ad\u30fc\u30de \u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u53d6\u308a\u307e\u3059\u304c\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u3092\u8aad\u307f\u53d6\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u898f\u5236\u74b0\u5883\u306e\u5834\u5408\u3001 <a href=\"https:\/\/www.gudusoft.com\/jp\/sqlflow-%e3%82%aa%e3%83%b3%e3%83%97%e3%83%ac%e3%83%9f%e3%82%b9-%e3%83%90%e3%83%bc%e3%82%b8%e3%83%a7%e3%83%b3\/\">SQLFlow \u30aa\u30f3\u30d7\u30ec\u30df\u30b9<\/a> runs on Docker or Kubernetes inside your network \u2014 air-gapped if required \u2014 so T-SQL source never leaves your infrastructure. Enterprise deployments batch-scan estates of 100+ databases and over a million columns with incremental scans, and export lineage to DataHub, Microsoft Purview, and OpenMetadata, so SQL Server lineage can flow into the catalog you already run. Pricing: the Cloud edition starts free ($49.99\/month premium); On-Premise is $500\/month or $4,800 one-time per database type \u2014 details on the <a href=\"https:\/\/www.gudusoft.com\/jp\/%e4%be%a1%e6%a0%bc%e8%a8%ad%e5%ae%9a\/\">\u4fa1\u683c\u30da\u30fc\u30b8<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306e\u30d1\u30fc\u30b5\u30fc\u3084\u30ab\u30bf\u30ed\u30b0\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306b\u3064\u3044\u3066\u306f\u3069\u3046\u3067\u3057\u3087\u3046\u304b\uff1f<\/h2>\n\n\n\n<p>\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30e9\u30a4\u30d6\u30e9\u30ea <code>SQL Lineage<\/code> \u3068 <code>sqlglot<\/code> \u500b\u3005\u306e\u30af\u30a8\u30ea\u306f\u3046\u307e\u304f\u89e3\u6790\u3055\u308c\u3001\u5358\u7d14\u306a SELECT \u304a\u3088\u3073 INSERT \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u306f\u305d\u308c\u3067\u5341\u5206\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002T-SQL \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3 \u30b3\u30fc\u30c9\u3067\u306f\u30ae\u30e3\u30c3\u30d7\u304c\u751f\u3058\u307e\u3059\u3002\u5236\u5fa1\u30d5\u30ed\u30fc\u3092\u6301\u3064\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u672c\u4f53\u3001 <code>#temp<\/code> \u30c6\u30fc\u30d6\u30eb\u306e\u72b6\u614b\u306f\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u9593\u3067\u3082\u5909\u308f\u308a\u307e\u305b\u3093\u3002 <code>\u30de\u30fc\u30b8<\/code> \u5206\u5c90\u89e3\u6790\u3084\u52d5\u7684SQL\u89e3\u6c7a\u306f\u3001\u6c4e\u7528\u30c4\u30fc\u30eb\u3067\u306f\u7701\u7565\u3055\u308c\u308b\u9ad8\u5ea6\u306a\u30d1\u30fc\u30b5\u30fc\u30a8\u30f3\u30b8\u30cb\u30a2\u30ea\u30f3\u30b0\u3067\u3059\u3002\u30ab\u30bf\u30ed\u30b0\u30d5\u30a1\u30fc\u30b9\u30c8\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306f\u3001\u8907\u6570\u306e\u30b7\u30b9\u30c6\u30e0\u306b\u308f\u305f\u308b\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u6574\u7406\u306b\u512a\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30ed\u30b8\u30c3\u30af\u306b\u3088\u308b\u5217\u306e\u7cfb\u7d71\u8ffd\u8de1\u306b\u306f\u3001\u901a\u5e38\u3001\u57fa\u76e4\u3068\u306a\u308b\u89e3\u6790\u30a8\u30f3\u30b8\u30f3\u304c\u5fc5\u8981\u3067\u3059\u3002SQLFlow\u306f\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3068\u3057\u3066\u3001\u3042\u308b\u3044\u306f\u3053\u308c\u3089\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3078\u306e\u7cfb\u7d71\u8ffd\u8de1\u30d5\u30a3\u30fc\u30c9\u3068\u3057\u3066\u3001\u307e\u3055\u306b\u305d\u306e\u5f79\u5272\u3092\u679c\u305f\u3057\u307e\u3059\u3002\u6700\u3082\u78ba\u5b9f\u306a\u30c6\u30b9\u30c8\u65b9\u6cd5\u306f\u3001\u6700\u3082\u9577\u3044\u672c\u756a\u74b0\u5883\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u5404\u5019\u88dc\u30c4\u30fc\u30eb\u3067\u5b9f\u884c\u3057\u3066\u307f\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u95a2\u9023\u3059\u308b\u7cfb\u8b5c\u30ac\u30a4\u30c9<\/h2>\n\n\n\n<ul><li><a href=\"https:\/\/www.gudusoft.com\/jp\/azure-sql-%e3%83%87%e3%83%bc%e3%82%bf%e3%83%aa%e3%83%8d%e3%83%bc%e3%82%b8\/\">Azure SQL \u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8<\/a> \u2014 \u540c\u3058 T-SQL \u5206\u6790\u3092 Azure SQL Database \u3068 Managed Instance \u306b\u9069\u7528\u3057\u307e\u3059\u3002<\/li>\n<li><a href=\"https:\/\/www.gudusoft.com\/jp\/%e3%82%aa%e3%83%a9%e3%82%af%e3%83%ab%e3%83%87%e3%83%bc%e3%82%bf%e7%b3%bb%e7%b5%b1\/\">Oracle \u30c7\u30fc\u30bf\u7cfb\u7d71\u30c4\u30fc\u30eb<\/a> \u2014 PL\/SQL\u306e\u624b\u7d9a\u304d\u578b\u7cfb\u7d71\u56f3\u3002\u3053\u306e\u30da\u30fc\u30b8\u306b\u76f8\u5f53\u3059\u308bOracle\u306e\u9805\u76ee\u3067\u3059\u3002<\/li>\n<li><a href=\"https:\/\/www.gudusoft.com\/jp\/sql-data-lineage-tool\/\">SQL\u30c7\u30fc\u30bf\u30ea\u30cd\u30fc\u30b8\u30c4\u30fc\u30eb\u306e\u6982\u8981<\/a> \u2014 SQLFlow\u304c\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b39\u7a2e\u985e\u306e\u3059\u3079\u3066\u306e\u65b9\u8a00\u3067\u3069\u306e\u3088\u3046\u306b\u52d5\u4f5c\u3059\u308b\u304b\u3002<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u3088\u304f\u3042\u308b\u8cea\u554f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306f\u3001SQL Server\u306e\u52d5\u7684SQL\u3092\u901a\u3058\u3066\u30c7\u30fc\u30bf\u306e\u6d41\u308c\u3092\u8ffd\u8de1\u3067\u304d\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002SQL \u306f\u6587\u5b57\u5217\u5909\u6570\u306b\u7d44\u307f\u7acb\u3066\u3089\u308c\u3001\u5b9f\u884c\u3055\u308c\u307e\u3057\u305f\u3002 <code>sp_executesql<\/code> \u307e\u305f <code>\u30a8\u30b0\u30bc\u30af\u30c6\u30a3\u30d6<\/code> \u52d5\u7684SQL\u306f\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u89e3\u6790\u5185\u3067\u89e3\u6c7a\u304a\u3088\u3073\u89e3\u6790\u3055\u308c\u308b\u305f\u3081\u3001\u95a2\u9023\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u3068\u5217\u304c\u30ea\u30cd\u30fc\u30b8\u30b0\u30e9\u30d5\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30ab\u30bf\u30ed\u30b0\u30d9\u30fc\u30b9\u306e\u4f9d\u5b58\u95a2\u4fc2\u30d3\u30e5\u30fc\u3067\u306f\u3001\u52d5\u7684SQL\u306f\u4e00\u5207\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306f#temp\u30c6\u30fc\u30d6\u30eb\u3068\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002\u5217\u306f\u4ee5\u4e0b\u3092\u901a\u3058\u3066\u8ffd\u8de1\u3055\u308c\u307e\u3059\u3002 <code>#temp<\/code> \u30c6\u30fc\u30d6\u30eb\u3068\u30c6\u30fc\u30d6\u30eb\u5909\u6570\u3092\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u9593\u3067\u5171\u6709\u3059\u308b\u305f\u3081\u3001\u30c7\u30fc\u30bf\u3092\u30b9\u30c6\u30fc\u30b8\u30f3\u30b0\u3059\u308b\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u3067\u306f <code>tempdb<\/code> \u30bd\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u6700\u7d42\u30bf\u30fc\u30b2\u30c3\u30c8\u307e\u3067\u3001\u9023\u7d9a\u3057\u305f1\u3064\u306e\u5217\u30ec\u30d9\u30eb\u306e\u30d1\u30b9\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u3053\u308c\u306fSSMS\u306e\u300c\u4f9d\u5b58\u95a2\u4fc2\u306e\u8868\u793a\u300d\u3068\u3069\u3046\u9055\u3046\u306e\u3067\u3059\u304b\uff1f<\/h3>\n\n\n<p>SSMS \u306e\u4f9d\u5b58\u95a2\u4fc2\u30d3\u30e5\u30fc\u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30ec\u30d9\u30eb\u306e\u53c2\u7167\u3092\u5831\u544a\u3057\u307e\u3059: \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3 A \u306f\u30c6\u30fc\u30d6\u30eb B \u3092\u53c2\u7167\u3057\u3066\u3044\u307e\u3059\u3002SQLFlow \u306f T-SQL \u672c\u4f53\u3092\u89e3\u6790\u3057\u3001\u3069\u306e\u30bd\u30fc\u30b9\u5217\u304c\u3069\u306e\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u306b\u30d5\u30a3\u30fc\u30c9\u3059\u308b\u304b\u3001\u3069\u306e\u5909\u63db\u3092\u4ecb\u3057\u3066 (\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u4ecb\u3057\u305f\u30d5\u30ed\u30fc\u3092\u542b\u3080) \u65b9\u5411\u4ed8\u304d\u306e\u5217\u30ec\u30d9\u30eb\u306e\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u3092\u5831\u544a\u3057\u307e\u3059\u3002 <code>\u30de\u30fc\u30b8<\/code>\u30ab\u30bf\u30ed\u30b0\u304c\u8ffd\u8de1\u3057\u306a\u3044\u52d5\u7684SQL\u3082\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\u306f\u79c1\u306eSQL Server\u30c7\u30fc\u30bf\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3092\u5fc5\u8981\u3068\u3057\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u3044\u3044\u3048\u3002SQLFlow\u306fSQL\u30b3\u30fc\u30c9\u306e\u9759\u7684\u89e3\u6790\u3092\u5b9f\u884c\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u30c6\u30fc\u30d6\u30eb\u3084\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5b9a\u7fa9\u306a\u3069\u306e\u30b9\u30ad\u30fc\u30de\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u53d6\u308a\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u53d6\u308b\u3053\u3068\u306f\u6c7a\u3057\u3066\u306a\u304f\u3001\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u7248\u3067\u306fSQL\u30c6\u30ad\u30b9\u30c8\u306f\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u5185\u306b\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u3069\u306e\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u3069\u306e\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u547c\u3073\u51fa\u3057\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002SQLFlow\u306f\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u9593\u306e\u547c\u3073\u51fa\u3057\u3092\u793a\u3059\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u306a\u547c\u3073\u51fa\u3057\u30b0\u30e9\u30d5\u3092\u5217\u306e\u7cfb\u7d71\u56f3\u3068\u4e26\u3079\u3066\u8868\u793a\u3059\u308b\u306e\u3067\u3001\u8907\u6570\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304b\u3089\u306a\u308bETL\u30c1\u30a7\u30fc\u30f3\u3092\u6700\u521d\u304b\u3089\u6700\u5f8c\u307e\u3067\u30ca\u30d3\u30b2\u30fc\u30c8\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Server\u306e\u7cfb\u7d71\u8ffd\u8de1\u6a5f\u80fd\u3092\u7121\u6599\u3067\u8a66\u7528\u3059\u308b\u65b9\u6cd5\u306f\u3042\u308a\u307e\u3059\u304b\uff1f<\/h3>\n\n\n<p>\u306f\u3044\u3002 <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=sql-server-data-lineage\">SQLFlow \u30af\u30e9\u30a6\u30c9<\/a> \u7121\u6599\u30d7\u30e9\u30f3\u304c\u3042\u308a\u3001\u30d6\u30e9\u30a6\u30b6\u306bT-SQL\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u3060\u3051\u3067\u3001\u5217\u30ec\u30d9\u30eb\u306e\u7cfb\u7d71\u56f3\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002\u30d7\u30ec\u30df\u30a2\u30e0\u30d7\u30e9\u30f3\u306f\u6708\u984d$49.99\u3067\u3001\u3088\u308a\u591a\u304f\u306e\u5165\u529b\u30c7\u30fc\u30bf\u3084API\u3078\u306e\u30a2\u30af\u30bb\u30b9\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained\" style=\"background-color:#60d5f6;padding-top:32px;padding-bottom:32px\"><div class=\"wp-block-group__inner-container\">\n\n<h2 class=\"wp-block-heading\">SQL Server\u306e\u7cfb\u7d71\u56f3\u3092\u4eca\u3059\u3050\u4f5c\u6210\u3057\u307e\u3057\u3087\u3046<\/h2>\n\n\n<p>\u6700\u3082\u8907\u96d1\u306a\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u7121\u6599\u306e\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30b6\u30fc\u306b\u8cbc\u308a\u4ed8\u3051\u308b\u304b\u3001SQL Server\u74b0\u5883\u5168\u4f53\u306e\u30b9\u30ad\u30e3\u30f3\u306b\u3064\u3044\u3066\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=sql-server-data-lineage\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow\u3092\u7121\u6599\u3067\u304a\u8a66\u3057\u304f\u3060\u3055\u3044<\/a><\/div>\n<\/div>\n\n\n<div class=\"wp-block-buttons is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.gudusoft.com\/jp\/%e3%82%b3%e3%83%b3%e3%82%bf%e3%82%af%e3%83%88\/\">\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba\u5411\u3051\u30c7\u30e2\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u3059\u308b<\/a><\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n\n<script type=\"application\/ld+json\">{\n    \"@context\": \"https:\\\/\\\/schema.org\",\n    \"@graph\": [\n        {\n            \"@type\": \"SoftwareApplication\",\n            \"name\": \"Gudu SQLFlow\",\n            \"applicationCategory\": \"DeveloperApplication\",\n            \"applicationSubCategory\": \"SQL Server Data Lineage Tool\",\n            \"operatingSystem\": \"Web, Linux, Windows, macOS\",\n            \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/sql-server-data-lineage\\\/\",\n            \"description\": \"Automated SQL Server data lineage tool with a dedicated T-SQL procedural parser: column-level lineage through stored procedures, temp tables, MERGE, and dynamic SQL, plus a procedure call graph.\",\n            \"featureList\": \"T-SQL stored procedure lineage, dynamic SQL resolution (sp_executesql\\\/EXEC), temp table and table variable tracking, MERGE analysis, procedure call graph, direct vs indirect lineage, JDBC metadata import, DataHub\\\/Purview\\\/OpenMetadata export\",\n            \"softwareVersion\": \"8.2.3\",\n            \"offers\": [\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Free\",\n                    \"price\": \"0\",\n                    \"priceCurrency\": \"USD\"\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow Cloud Premium\",\n                    \"price\": \"49.99\",\n                    \"priceCurrency\": \"USD\",\n                    \"priceSpecification\": {\n                        \"@type\": \"UnitPriceSpecification\",\n                        \"price\": \"49.99\",\n                        \"priceCurrency\": \"USD\",\n                        \"billingIncrement\": 1,\n                        \"unitText\": \"MONTH\"\n                    }\n                },\n                {\n                    \"@type\": \"Offer\",\n                    \"name\": \"SQLFlow On-Premise\",\n                    \"price\": \"4800\",\n                    \"priceCurrency\": \"USD\"\n                }\n            ],\n            \"publisher\": {\n                \"@type\": \"Organization\",\n                \"name\": \"Gudu Software\",\n                \"url\": \"https:\\\/\\\/www.gudusoft.com\\\/\"\n            }\n        },\n        {\n            \"@type\": \"FAQPage\",\n            \"mainEntity\": [\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can SQLFlow trace lineage through SQL Server dynamic SQL?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQL assembled in string variables and executed with sp_executesql or EXEC is resolved and parsed inside the procedure analysis, so the tables and columns it touches appear in the lineage graph. Catalog-based dependency views cannot see dynamic SQL at all.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow handle #temp tables and table variables?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. Columns are tracked through #temp tables and table variables across statements, so a pipeline that stages data in tempdb shows up as one continuous column-level path from source table to final target.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"How is this different from View Dependencies in SSMS?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"SSMS dependency views report object-level references: procedure A mentions table B. SQLFlow parses the T-SQL bodies and reports column-level dataflow with direction \\u2014 which source columns feed which target columns, through which transformations \\u2014 including flows through temp tables, MERGE, and dynamic SQL that the catalog does not track.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Does SQLFlow need access to my SQL Server data?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"No. SQLFlow performs static analysis of SQL code and optionally reads schema metadata such as table and procedure definitions. It never reads table row data, and the On-Premise edition keeps SQL text inside your network.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Can I see which stored procedures call which?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow renders an interactive call graph of procedure-to-procedure invocations alongside the column lineage, so you can navigate a multi-procedure ETL chain end to end.\"\n                    }\n                },\n                {\n                    \"@type\": \"Question\",\n                    \"name\": \"Is there a free way to try SQL Server lineage?\",\n                    \"acceptedAnswer\": {\n                        \"@type\": \"Answer\",\n                        \"text\": \"Yes. SQLFlow Cloud has a free tier: paste T-SQL in the browser and get a column-level lineage diagram. Premium is $49.99\\\/month for larger inputs and API access.\"\n                    }\n                }\n            ]\n        }\n    ]\n}<\/script>","protected":false},"excerpt":{"rendered":"<p>SQL Server data lineage is the column-level map of how data moves through your T-SQL code: which source columns feed each target table, view, or report, and what happens along the way inside stored procedures, temp tables, MERGE statements, and dynamic SQL. Gudu SQLFlow builds that map automatically by parsing T-SQL with a dedicated SQL Server procedural parser, so lineage does not stop at the object level the way SSMS dependency views do. Try it now: paste a T-SQL stored procedure into the free SQL Server lineage visualizer and get a column-level lineage diagram in seconds. Why SQL Server data\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/pages\/6754"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/comments?post=6754"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/pages\/6754\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/jp\/wp-json\/wp\/v2\/media?parent=6754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}