{"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\/ko\/sql-%ec%84%9c%eb%b2%84-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"SQL Server \ub370\uc774\ud130 \uacc4\ubcf4: T-SQL, \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubc0f \ub3d9\uc801 SQL"},"content":{"rendered":"<p><strong>SQL Server \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> T-SQL \ucf54\ub4dc\uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc5b4\ub5bb\uac8c \uc774\ub3d9\ud558\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\ub294 \uc5f4 \uc218\uc900 \ub9f5\uc785\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \uc18c\uc2a4 \uc5f4\uc774 \uac01 \ub300\uc0c1 \ud14c\uc774\ube14, \ubdf0 \ub610\ub294 \ubcf4\uace0\uc11c\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800, \uc784\uc2dc \ud14c\uc774\ube14 \ub0b4\ubd80\uc5d0\uc11c \uc5b4\ub5a4 \uc77c\uc774 \ubc1c\uc0dd\ud558\ub294\uc9c0\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. <code>\ubcd1\ud569<\/code> \ubb38\uc7a5 \ubc0f \ub3d9\uc801 SQL. <a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">Gudu SQLFlow<\/a> \uc774 \uae30\ub2a5\uc740 \uc804\uc6a9 SQL Server \ud504\ub85c\uc2dc\uc800 \ud30c\uc11c\ub97c \uc0ac\uc6a9\ud558\uc5ec T-SQL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud568\uc73c\ub85c\uc368 \ud574\ub2f9 \ub9f5\uc744 \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ud558\ubbc0\ub85c SSMS \uc885\uc18d\uc131 \ubcf4\uae30\ucc98\ub7fc \uac1c\uccb4 \uc218\uc900\uc5d0\uc11c \uacc4\ubcf4\uac00 \uc911\ub2e8\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/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>\uc9c0\uae08 \ubc14\ub85c \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> T-SQL \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \ubd99\uc5ec\ub123\uc73c\uc138\uc694 <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\">\ubb34\ub8cc SQL Server \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a> \uadf8\ub9ac\uace0 \uba87 \ucd08 \ub9cc\uc5d0 \uc5f4 \uc218\uc900\uc758 \uacc4\ubcf4\ub3c4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server \ub370\uc774\ud130 \uacc4\ubcf4 \ucd94\uc801\uc774 \uc0dd\uac01\ubcf4\ub2e4 \uc5b4\ub824\uc6b4 \uc774\uc720<\/h2>\n\n\n\n<p>\ub300\ubd80\ubd84\uc758 SQL Server \ud658\uacbd\uc5d0\uc11c \uc2e4\uc81c\ub85c \uc911\uc694\ud55c \ubcc0\ud658 \ub85c\uc9c1\uc740 \uae54\ub054\ud55c \ubdf0\uc5d0 \uc788\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \ub370\uc774\ud130\ub97c \ub2e8\uacc4\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. <code>#temp<\/code> \ud14c\uc774\ube14, \uc0ac\uc2e4 \ud14c\uc774\ube14\uc5d0 upsert <code>\ubcd1\ud569<\/code>\ub9e4\uac1c\ubcc0\uc218\uc5d0 \ub530\ub77c \ubd84\uae30\ud558\uace0 \ub7f0\ud0c0\uc784\uc5d0 SQL \ubb38\uc790\uc5f4\uc744 \uad6c\uc131\ud569\ub2c8\ub2e4. <code>sp_executesql<\/code> \ub610\ub294 <code>\uc784\uc6d0<\/code>\uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \uac1d\uccb4 \uc815\uc758\ub9cc \uc77d\ub294 \ubaa8\ub4e0 \uacc4\ubcf4 \uc811\uadfc \ubc29\uc2dd\uc740 \ud504\ub85c\uc2dc\uc800\ub97c \ube14\ub799\ubc15\uc2a4\ub85c \uac04\uc8fc\ud569\ub2c8\ub2e4. \uc989, \ud504\ub85c\uc2dc\uc800\uac00 \uc874\uc7ac\ud55c\ub2e4\ub294 \uac83\uc740 \uc54c\uc9c0\ub9cc \uc5b4\ub5a4 \uc5f4\uc774 \ud504\ub85c\uc2dc\uc800\ub97c \ud1b5\ud574 \uc804\ub2ec\ub418\ub294\uc9c0\ub294 \uc54c \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud574\ub2f9 \ucf54\ub4dc\uc5d0\uc11c \uc9c4\uc815\ud55c \uacc4\ubcf4\ub97c \ud30c\uc545\ud558\ub824\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c4\uc774 T-SQL\uc744 \ud30c\uc2f1\ud558\ub294 \ubc29\uc2dd\ub300\ub85c \ubd84\uc11d\ud574\uc57c \ud569\ub2c8\ub2e4. \uc989, \ud504\ub85c\uc2dc\uc800 \ubcf8\ubb38\uc758 \ubaa8\ub4e0 \ubb38\uc7a5\uc5d0 \ub300\ud55c \uc758\ubbf8 \ubaa8\ub378\uc744 \uad6c\ucd95\ud558\uace0, \uc784\uc2dc \ud14c\uc774\ube14\uacfc \ud14c\uc774\ube14 \ubcc0\uc218\ub97c \uac70\uce58\ub294 \uc5f4\uc744 \ucd94\uc801\ud558\uba70, \ubb38\uc790\uc5f4 \ubcc0\uc218 \uc548\uc5d0 \uc228\uaca8\uc9c4 SQL\uc744 \ud574\uc11d\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub294 \uba54\ud0c0\ub370\uc774\ud130 \ucffc\ub9ac \ubb38\uc81c\uac00 \uc544\ub2c8\ub77c \ucef4\ud30c\uc77c\ub7ec \ubb38\uc81c\uc774\uba70, SQLFlow\uc758 T-SQL \ud30c\uc11c\ub294 \ubc14\ub85c \uc774\ub7ec\ud55c \uc791\uc5c5\uc744 \uc704\ud574 \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SSMS \uc885\uc18d\uc131 \ubcf4\uae30\uc5d0\uc11c \uc54c \uc218 \uc788\ub294 \uac83\uacfc \uc54c \uc218 \uc5c6\ub294 \uac83<\/h2>\n\n\n\n<p>SQL Server\ub294 \uc720\uc6a9\ud55c \uc885\uc18d\uc131 \uad00\ub9ac \ub3c4\uad6c\ub97c \uc81c\uacf5\ud558\uba70, \uac1d\uccb4 \uc218\uc900\uc758 \uac04\ub2e8\ud55c \uc9c8\ubb38\uc744 \ud560 \ub54c \uac00\uc7a5 \uba3c\uc800 \ucc3e\uc544\uc57c \ud560 \uacf3\uc785\ub2c8\ub2e4. <code>sys.sql_expression_dependencies<\/code>, <code>sys.dm_sql_\ucc38\uc870\ub41c \uc5d4\ud2f0\ud2f0<\/code>SSMS\uc758 &quot;\uc885\uc18d\uc131 \ubcf4\uae30&quot; \ub300\ud654 \uc0c1\uc790\ub294 \ud504\ub85c\uc2dc\uc800 A\uac00 \ud14c\uc774\ube14 B\ub97c \ucc38\uc870\ud55c\ub2e4\ub294 \uc0ac\uc2e4\uc744 \ud655\uc2e4\ud558\uac8c \uc54c\ub824\uc90d\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub2e4\uc74c\uacfc \uac19\uc740 \uc0ac\uc2e4\uc740 \uc54c\ub824\uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li><strong>\uceec\ub7fc \ub808\ubca8 \ud750\ub984.<\/strong> \uce74\ud0c8\ub85c\uadf8 \uc885\uc18d\uc131\uc740 \uac1d\uccb4 \uc218\uc900\uc5d0\uc11c \uba48\ucda5\ub2c8\ub2e4. \uc774\ub294 \ub2e4\uc74c\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <code>usp_load_fact_sales<\/code> \ud130\uce58 <code>\uc2a4\ud14c\uc774\uc9d5.\uc138\uc77c\uc988<\/code> \uadf8\ub9ac\uace0 <code>dw.fact_sales<\/code>\ud558\uc9c0\ub9cc \uadf8\uac74 \uc544\ub2c8\uc57c <code>\uc0ac\uc2e4_\ud310\ub9e4\uc561<\/code> ~\uc5d0\uc11c \ud30c\uc0dd\ub428 <code>\uc2a4\ud14c\uc774\uc9d5.\ud310\ub9e4.\uae08\uc561<\/code> ~\uc744 \ud1b5\ud574 <code>\uae41\uc2a4<\/code> ~\ud558\ub294 \ub3d9\uc548 <code>\uc2a4\ud14c\uc774\uc9d5.\ud310\ub9e4.\ub85c\ub4dc_\ub0a0\uc9dc<\/code> \ud589\ub9cc \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ud750\ub984\uc758 \ubc29\ud5a5.<\/strong> \ucc38\uc870\ub294 \ub370\uc774\ud130 \ud750\ub984\uc774 \uc544\ub2d9\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0\uc11c \uc77d\uace0 \uc4f0\ub294 \uc791\uc5c5\uc740 \ub3d9\uc77c\ud55c \uc885\uc18d\uc131 \ud589\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \uc5b4\ub290 \uac83\uc774 \uc18c\uc2a4\uc774\uace0 \uc5b4\ub290 \uac83\uc774 \ub300\uc0c1\uc778\uc9c0 \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ub3d9\uc801 SQL.<\/strong> \ubb38\uc790\uc5f4\ub85c \uad6c\uc131\ub41c \ubb38\uc7a5\ub4e4\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4. <code>sp_executesql<\/code> \ub610\ub294 <code>\uc784\uc6d0<\/code> \uc774\ub7ec\ud55c \uc694\uc18c\ub4e4\uc740 \ub7f0\ud0c0\uc784 \uc804\uae4c\uc9c0\ub294 \uc874\uc7ac\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \uc885\uc18d\uc131 \uce74\ud0c8\ub85c\uadf8\uc5d0 \uc804\ud600 \ud45c\uc2dc\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\uc784\uc2dc \ud14c\uc774\ube14 \ud649.<\/strong> <code>#temp<\/code> \ud14c\uc774\ube14\uc740 \uc0b4\uc544\uc788\uc2b5\ub2c8\ub2e4 <code>tempdb<\/code> \ub610\ud55c \uc885\uc18d\uc131 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub85c \ucd94\uc801\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c, \uc774\ub97c \ud1b5\uacfc\ud558\ub294 \ubaa8\ub4e0 \uacc4\ubcf4\ub294 \uc808\ubc18\uc73c\ub85c \uc798\ub9bd\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>&quot;\uc774 \uc5f4\uc744 \ub2e4\uc2dc \uc785\ub825\ud558\uba74 \ud558\uc704 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294\uac00?&quot; \ub610\ub294 &quot;\uc774 \uaddc\uc81c \ubcf4\uace0\uc11c\uc5d0 \uc5b4\ub5a4 \uc18c\uc2a4 \ud544\ub4dc\uac00 \uc0ac\uc6a9\ub418\ub294\uac00?&quot;\uc640 \uac19\uc740 \uc9c8\ubb38\uc5d0 \ub2f5\ud558\ub824\uba74 T-SQL \ubcf8\ubb38\uc744 \uc9c1\uc811 \ubd84\uc11d\ud574\uc57c \ud569\ub2c8\ub2e4. SQLFlow\ub294 \uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \uc774\ubbf8 \uc81c\uacf5\ud558\ub294 \uae30\ub2a5 \uc704\uc5d0 \ubc14\ub85c \uc774 \ubd80\ubd84\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQLFlow\ub294 T-SQL \ud504\ub85c\uc2dc\uc800\ub97c \ud1b5\ud574 \uc5b4\ub5bb\uac8c \uacc4\ubcf4\ub97c \ucd94\uc801\ud558\ub294\uac00<\/h2>\n\n\n\n<p>SQLFlow\ub294 \ub2e4\uc74c\uc744 \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.sqlparser.com\/\">\uc77c\ubc18 SQL \ud30c\uc11c(GSP)<\/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>\uc784\uc2dc \ud14c\uc774\ube14\uacfc \ud14c\uc774\ube14 \ubcc0\uc218.<\/strong> \uceec\ub7fc\uc740 \ub2e4\uc74c\uc744 \ud1b5\ud574 \ucd94\uc801\ub429\ub2c8\ub2e4. <code>SELECT ... INTO #staging<\/code>, <code>@rows \ud14c\uc774\ube14\uc5d0 \uc0bd\uc785<\/code>\uadf8\ub9ac\uace0 \uadf8 \uc774\ud6c4\uc758 \ubaa8\ub4e0 \uc77d\uae30 \uc791\uc5c5\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub85c, 3\ub2e8\uacc4 \ud30c\uc774\ud504\ub77c\uc778\uc744 \uac70\uce58\uac8c \ub429\ub2c8\ub2e4. <code>tempdb<\/code> \ud558\ub098\uc758 \uc5f0\uc18d\uc801\uc778 \uacc4\ubcf4 \uacbd\ub85c\ub85c \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/li>\n<li><strong><code>\ubcd1\ud569<\/code> \uc9c4\uc220.<\/strong> \uac01 <code>\uc77c\uce58\ud558\ub294 \uacbd\uc6b0 \uc5c5\ub370\uc774\ud2b8<\/code> \uadf8\ub9ac\uace0 <code>\uc77c\uce58\ud558\uc9c0 \uc54a\uc73c\uba74 \uc0bd\uc785\ud558\uc2ed\uc2dc\uc624<\/code> \ubd84\uae30\ub97c \ubd84\uc11d\ud558\uc5ec \uc18c\uc2a4 \uc5f4\uc744 \ub300\uc0c1 \uc5f4\uc5d0 \ub9e4\ud551\ud558\uace0 \ucc98\ub9ac\ud569\ub2c8\ub2e4. <code>\uc5d0<\/code> \uac04\uc811 \ud608\ud1b5\uc73c\ub85c\uc11c\uc758 \uc0c1\ud0dc.<\/li>\n<li><strong>\ub3d9\uc801 SQL.<\/strong> SQL \ucffc\ub9ac\uac00 \ubcc0\uc218\ub85c \uad6c\uc131\ub418\uace0 \uc2e4\ud589\ub429\ub2c8\ub2e4. <code>sp_executesql<\/code> \ub610\ub294 <code>\uc784\uc6d0<\/code> \uac74\ub108\ub6f0\ub294 \ub300\uc2e0 \ud574\uacb0 \ubc0f \uad6c\ubb38 \ubd84\uc11d\ub429\ub2c8\ub2e4. \uc774\ub294 \uacc4\ubcf4 \ub3c4\uad6c\uc5d0\uc11c \uac00\uc7a5 \ud754\ud55c \uc0ac\uac01\uc9c0\ub300 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>\uc808\ucc28 \ub9e4\uac1c\ubcc0\uc218.<\/strong> \uacc4\ubcf4\ub294 \ub9e4\uac1c\ubcc0\uc218 \uac12\uc744 \ud1b5\ud574 \ud574\ub2f9 \uac12\uc744 \uc0ac\uc6a9\ud558\ub294 \ubb38\uc7a5\uc73c\ub85c \uc774\uc5b4\uc9d1\ub2c8\ub2e4.<\/li>\n<li><strong>\ud1b5\ud654\ub7c9 \uadf8\ub798\ud504.<\/strong> \ud504\ub85c\uc2dc\uc800\uac00 \ub2e4\ub978 \ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud560 \ub54c SQLFlow\ub294 \ud504\ub85c\uc2dc\uc800 \uac04 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \ub300\ud654\ud615\uc73c\ub85c \ud45c\uc2dc\ud558\ubbc0\ub85c \uac1c\ubcc4 \ud504\ub85c\uc2dc\uc800\uac00 \uc544\ub2cc \uc804\uccb4 ETL \uccb4\uc778\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\uc608\uc2dc: MERGE\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud14c\uc774\uc9d5 \ud14c\uc774\ube14\uc744 \ud329\ud2b8 \ud14c\uc774\ube14\ub85c \ubcc0\ud658<\/h2>\n\n\n\n<p>\ub2e4\uc74c\uc740 \ubaa8\ub4e0 SQL Server \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc5d0 \ud3ec\ud568\ub41c \ud504\ub85c\uc2dc\uc800\uc758 \ud55c \uc885\ub958\uc785\ub2c8\ub2e4. \uc774 \ud504\ub85c\uc2dc\uc800\ub294 \uc2a4\ud14c\uc774\uc9d5 \ud589\uc744 \uc784\uc2dc \ud14c\uc774\ube14\ub85c \uc815\ub9ac\ud55c \ub2e4\uc74c, \uc774\ub97c \ud329\ud2b8 \ud14c\uc774\ube14\ub85c \ubcd1\ud569\ud569\ub2c8\ub2e4.<\/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>SQLFlow\ub97c \ud1b5\ud574 \uc2e4\ud589\ud558\uba74 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <code>dw.fact_sales.amount<\/code> ~\uc5d0 \uc758\ud574 \uacf5\uae09\ub428 <code>\uc2a4\ud14c\uc774\uc9d5.\ud310\ub9e4.\uae08\uc561<\/code> ~\uc744 \ud1b5\ud574 <code>\uae41\uc2a4<\/code>, \uc640 \ud568\uaed8 <code>#clean_sales<\/code> \uc911\uac04 \ub2e8\uacc4\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ub610\ud55c \uce74\ud0c8\ub85c\uadf8 \ucffc\ub9ac\ub85c\ub294 \uc808\ub300 \uc0dd\uc131\ud560 \uc218 \uc5c6\ub294 \ub450 \uac00\uc9c0 \uad00\uacc4\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <code>\uc2a4\ud14c\uc774\uc9d5.\ud310\ub9e4.\ub85c\ub4dc_\ub0a0\uc9dc<\/code> \ubaa8\ub4e0 \ucd9c\ub825 \uc5f4\uc5d0 \ub300\ud55c \uac04\uc811\uc801\uc778 \uacc4\ubcf4 \uc5ed\ud560\uc744 \ud558\uba70(\uc5b4\ub5a4 \ud589\uc774 \ub85c\ub4dc\ub420\uc9c0 \uacb0\uc815\ud568), <code>\uc8fc\ubb38 ID<\/code> \uc0bd\uc785\ub41c \ud0a4\ub85c\uc758 \uc9c1\uc811\uc801\uc778 \uacc4\ubcf4\uc640 \uc774\ub97c \ud1b5\ud55c \uac04\uc811\uc801\uc778 \uacc4\ubcf4, \ub450 \uac00\uc9c0 \uc5ed\ud560\uc744 \ub3d9\uc2dc\uc5d0 \uc218\ud589\ud569\ub2c8\ub2e4. <code>\ubcd1\ud569... \ucf1c\uc9d0<\/code> \uacbd\uae30 \uc870\uac74.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">T-SQL\uc5d0\uc11c \uc9c1\uc811 \uacc4\ubcf4\uc640 \uac04\uc811 \uacc4\ubcf4\uc758 \ucc28\uc774\uc810<\/h2>\n\n\n\n<p>SQLFlow\ub294 \uad6c\ubcc4\ud569\ub2c8\ub2e4 <strong>\uc9c1\uacc4 \ud608\ud1b5<\/strong> (\uc6d0\ubcf8 \uc5f4\uc758 \uac12\uc774 \ub300\uc0c1 \uc5f4\uc5d0 \uc800\uc7a5\ub428) <strong>\uac04\uc811 \ud608\ud1b5<\/strong> (\uc5f4\uc740 \uacb0\uacfc\ub97c \ud1b5\ud574 \ubaa8\uc591\uc744 \ub9cc\ub4ed\ub2c8\ub2e4) <code>\uc5b4\ub514<\/code> \uc808, <code>\uac00\uc785\ud558\ub2e4<\/code> \ub610\ub294 <code>\ubcd1\ud569 \uc2dc\uc791<\/code> \uc0c1\ud0dc, <code>\uadf8\ub8f9\ud654 \uae30\uc900<\/code>(\ub610\ub294 \uc9d1\uacc4). \uc774 \ub450 \uac00\uc9c0\ub294 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \uac1c\ubcc4\uc801\uc73c\ub85c \ucf1c\uace0 \ub04c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ub300\ubd80\ubd84\uc758 \ub2e4\ub978 \ubc29\uc5b8\ubcf4\ub2e4 T-SQL \uc791\uc5c5\uc5d0\uc11c \ub354 \uc911\uc694\ud569\ub2c8\ub2e4. \ub85c\ub4dc \ud504\ub85c\uc2dc\uc800\uc5d0\ub294 \ucd9c\ub825\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc9c0\ub9cc \uc5b4\ub5a4 \ub370\uc774\ud130\uac00 \uc804\ub2ec\ub420\uc9c0\ub97c \uc870\uc6a9\ud788 \uc81c\uc5b4\ud558\ub294 \ud544\ud130 \uc5f4(\ubc30\uce58 \ub0a0\uc9dc, \uc0c1\ud0dc \ud50c\ub798\uadf8, \uc6cc\ud130\ub9c8\ud06c \uc5f4)\uc774 \ub9ce\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad6c\ubd84\uc744 \uc804\ud600 \ubaa8\ub378\ub9c1\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub85c\ub4dc \ud504\ub85c\uc2dc\uc800\uc5d0 \ub300\ud55c \uc601\ud5a5 \ubd84\uc11d\uc5d0\uc11c \uc774\ub7ec\ud55c \uad6c\ubd84\uc774 \uc885\uc885 \ubb38\uc81c\ub97c \uc77c\uc73c\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server \uacc4\ubcf4 \uac00\uc838\uc624\uae30: \uc785\ub825 \ubc0f \ubc30\ud3ec<\/h2>\n\n\n\n<p>SQLFlow\uc5d0 SQL Server \ucf54\ub4dc\ub97c \uc804\ub2ec\ud558\ub294 \ubc29\ubc95\uc740 \ud658\uacbd\uc758 \ubcf4\uc548 \uc218\uc900\uc5d0 \ub530\ub77c \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc785\ub825<\/th><th>\uc791\ub3d9 \ubc29\uc2dd<\/th><th>\uc88b\uc740<\/th><\/tr><\/thead><tbody>\n<tr><td>T-SQL\uc744 \ubd99\uc5ec\ub123\uac70\ub098 \uc5c5\ub85c\ub4dc\ud558\uc138\uc694.<\/td><td>\uc2a4\ud06c\ub9bd\ud2b8, DDL \ubc0f \ud504\ub85c\uc2dc\uc800 \uc815\uc758\ub294 \ud30c\uc77c \ub610\ub294 \ubd99\uc5ec\ub123\uc740 \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc785\ub2c8\ub2e4.<\/td><td>\uc2e0\uc18d\ud55c \ubd84\uc11d, \ucf54\ub4dc \uac80\ud1a0, \ud55c \ubc88\uc5d0 \ud55c \uc808\ucc28\uc529<\/td><\/tr>\n<tr><td>JDBC\ub97c \ud1b5\ud55c \uc2e4\uc2dc\uac04 \uba54\ud0c0\ub370\uc774\ud130<\/td><td>SQLFlow\ub294 \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c DDL, \ubdf0 \ubc0f \ud504\ub85c\uc2dc\uc800 \uc815\uc758\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/td><td>\uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uacc4\ubcf4\uac00 \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/td><\/tr>\n<tr><td>Grabit \uba54\ud0c0\ub370\uc774\ud130 \ucd94\ucd9c<\/td><td>\uc624\ud504\ub77c\uc778 \ucd94\ucd9c \uc720\ud2f8\ub9ac\ud2f0\ub294 \uba54\ud0c0\ub370\uc774\ud130\ub97c SQLFlow\ub85c \uc804\uc1a1\ud569\ub2c8\ub2e4.<\/td><td>\uacc4\ubcf4 \uc11c\ubc84\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \uc218 \uc5c6\ub294 \ud658\uacbd<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n<p>\ubaa8\ub4e0 \uacbd\uc6b0\uc5d0 \ubd84\uc11d\uc740 \uc815\uc801\uc785\ub2c8\ub2e4. SQLFlow\ub294 SQL \ucf54\ub4dc\uc640 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc77d\uc73c\uba70 \ud14c\uc774\ube14\uc758 \ud589\uc740 \uc77d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uaddc\uc81c \ud658\uacbd\uc758 \uacbd\uc6b0, <a href=\"https:\/\/www.gudusoft.com\/ko\/sqlflow-on-premise-%eb%b2%84%ec%a0%84\/\">\uc628\ud504\ub808\ubbf8\uc2a4 SQLFlow<\/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\/ko\/%ea%b0%80%ea%b2%a9\/\">\uac00\uaca9 \ud398\uc774\uc9c0<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc624\ud508\uc18c\uc2a4 \ud30c\uc11c\uc640 \uce74\ud0c8\ub85c\uadf8 \ud50c\ub7ab\ud3fc\uc740 \uc5b4\ub5bb\uc2b5\ub2c8\uae4c?<\/h2>\n\n\n\n<p>\uc624\ud508\uc18c\uc2a4 \ub77c\uc774\ube0c\ub7ec\ub9ac <code>sqllineage<\/code> \uadf8\ub9ac\uace0 <code>sqlglot<\/code> \uac1c\ubcc4 \ucffc\ub9ac\ub97c \uc798 \ud30c\uc2f1\ud558\uba74 \uc77c\ubc18\uc801\uc778 SELECT \ubc0f INSERT \ubb38\uc5d0\ub294 \ucda9\ubd84\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc T-SQL \ud504\ub85c\uc2dc\uc800 \ucf54\ub4dc, \uc989 \uc81c\uc5b4 \ud750\ub984\uc774 \uc788\ub294 \ud504\ub85c\uc2dc\uc800 \ubcf8\ubb38\uc5d0\uc11c\ub294 \ucc28\uc774\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. <code>#temp<\/code> \ubb38\uc7a5 \uac04 \ud14c\uc774\ube14 \uc0c1\ud0dc, <code>\ubcd1\ud569<\/code> \ubd84\uae30 \ubd84\uc11d \ubc0f \ub3d9\uc801 SQL \ud574\uc11d\uc740 \uc77c\ubc18\uc801\uc778 \ub3c4\uad6c\uac00 \uac74\ub108\ub6f0\ub294 \ud558\ub4dc \ud30c\uc11c \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1 \uc791\uc5c5\uc785\ub2c8\ub2e4. \uce74\ud0c8\ub85c\uadf8 \uc6b0\uc120 \ud50c\ub7ab\ud3fc\uc740 \uc5ec\ub7ec \uc2dc\uc2a4\ud15c\uc5d0 \uac78\uccd0 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uad6c\uc131\ud558\ub294 \ub370 \uac15\uc810\uc744 \uac00\uc9c0\uace0 \uc788\uc9c0\ub9cc, \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800 \ub85c\uc9c1\uc744 \ud1b5\ud55c \uc5f4 \uacc4\ubcf4 \ucd94\uc801\uc744 \uc704\ud574\uc11c\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ud30c\uc2f1 \uc5d4\uc9c4\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. SQLFlow\ub294 \ubc14\ub85c \uc774\ub7ec\ud55c \uc5ed\ud560\uc744 \ud558\uba70, \ub3c5\ub9bd \uc2e4\ud589\ud615\uc73c\ub85c \uc0ac\uc6a9\ub418\uac70\ub098 \ud574\ub2f9 \ud50c\ub7ab\ud3fc\uc5d0 \uacc4\ubcf4 \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \uac00\uc7a5 \ud655\uc2e4\ud55c \ud14c\uc2a4\ud2b8 \ubc29\ubc95\uc740 \uc2e4\uc81c \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c \uac00\uc7a5 \uae34 \ud504\ub85c\uc2dc\uc800\ub97c \uac00\uc838\uc640 \uac01 \ud6c4\ubcf4 \ub3c4\uad6c\ub97c \ud1b5\ud574 \uc2e4\ud589\ud574 \ubcf4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uad00\ub828 \uacc4\ubcf4 \uac00\uc774\ub4dc<\/h2>\n\n\n\n<ul><li><a href=\"https:\/\/www.gudusoft.com\/ko\/azure-sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/\">Azure SQL \ub370\uc774\ud130 \uacc4\ubcf4<\/a> \u2014 \ub3d9\uc77c\ud55c T-SQL \ubd84\uc11d\uc774 Azure SQL Database \ubc0f Managed Instance\uc5d0 \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<li><a href=\"https:\/\/www.gudusoft.com\/ko\/%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">Oracle \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c<\/a> \u2014 PL\/SQL \ud504\ub85c\uc2dc\uc800 \uacc4\ubcf4, \uc774 \ud398\uc774\uc9c0\uc5d0 \ud574\ub2f9\ud558\ub294 Oracle \ubc84\uc804\uc785\ub2c8\ub2e4.<\/li>\n<li><a href=\"https:\/\/www.gudusoft.com\/ko\/sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4-%eb%8f%84%ea%b5%ac\/\">SQL \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c \uac1c\uc694<\/a> \u2014 SQLFlow\uac00 \uc9c0\uc6d0\ub418\ub294 39\uac1c \ubc29\uc5b8 \ubaa8\ub450\uc5d0\uc11c \uc791\ub3d9\ud558\ub294 \ubc29\uc2dd.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 SQL Server \ub3d9\uc801 SQL\uc744 \ud1b5\ud574 \ucd94\uc801 \uacc4\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. SQL\uc740 \ubb38\uc790\uc5f4 \ubcc0\uc218\uc5d0 \uad6c\uc131\ub418\uc5b4 \uc2e4\ud589\ub429\ub2c8\ub2e4. <code>sp_executesql<\/code> \ub610\ub294 <code>\uc784\uc6d0<\/code> \ud504\ub85c\uc2dc\uc800 \ubd84\uc11d \ub0b4\ubd80\uc5d0\uc11c \ud574\uacb0 \ubc0f \uad6c\ubb38 \ubd84\uc11d\ub418\ubbc0\ub85c \ud574\ub2f9 \ud504\ub85c\uc2dc\uc800\uac00 \ucc38\uc870\ud558\ub294 \ud14c\uc774\ube14\uacfc \uc5f4\uc774 \uacc4\ubcf4 \uadf8\ub798\ud504\uc5d0 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uce74\ud0c8\ub85c\uadf8 \uae30\ubc18 \uc885\uc18d\uc131 \ubcf4\uae30\uc5d0\uc11c\ub294 \ub3d9\uc801 SQL\uc744 \uc804\ud600 \ubcfc \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 #temp \ud14c\uc774\ube14\uacfc \ud14c\uc774\ube14 \ubcc0\uc218\ub97c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\uae4c?<\/h3>\n\n\n<p>\uc608. \uc5f4\uc740 \ub2e4\uc74c\uc744 \ud1b5\ud574 \ucd94\uc801\ub429\ub2c8\ub2e4. <code>#temp<\/code> \ubb38\uc7a5 \uc804\uccb4\uc5d0 \uac78\uccd0 \ud14c\uc774\ube14\uacfc \ud14c\uc774\ube14 \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\ubbc0\ub85c \ub370\uc774\ud130\ub97c \uc900\ube44\ud558\ub294 \ud30c\uc774\ud504\ub77c\uc778\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <code>tempdb<\/code> \uc6d0\ubcf8 \ud14c\uc774\ube14\uc5d0\uc11c \ucd5c\uc885 \ub300\uc0c1 \ud14c\uc774\ube14\uae4c\uc9c0 \ud558\ub098\uc758 \uc5f0\uc18d\uc801\uc778 \uc5f4 \uc218\uc900 \uacbd\ub85c\ub85c \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SSMS\uc758 \ubdf0 \uc885\uc18d\uc131\uacfc\ub294 \uc5b4\ub5bb\uac8c \ub2e4\ub978\uac00\uc694?<\/h3>\n\n\n<p>SSMS \uc885\uc18d\uc131 \ubcf4\uae30\uc5d0\uc11c\ub294 \uac1d\uccb4 \uc218\uc900 \ucc38\uc870\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ud504\ub85c\uc2dc\uc800 A\uac00 \ud14c\uc774\ube14 B\ub97c \ucc38\uc870\ud558\ub294 \uacbd\uc6b0\uc785\ub2c8\ub2e4. SQLFlow\ub294 T-SQL \ubcf8\ubb38\uc744 \uad6c\ubb38 \ubd84\uc11d\ud558\uace0 \uc5f4 \uc218\uc900 \ub370\uc774\ud130 \ud750\ub984\uc744 \ubc29\ud5a5\uacfc \ud568\uaed8 \ubcf4\uace0\ud569\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \uc6d0\ubcf8 \uc5f4\uc774 \uc5b4\ub5a4 \ub300\uc0c1 \uc5f4\uc5d0 \uc5b4\ub5a4 \ubcc0\ud658\uc744 \uac70\uccd0 \uc804\ub2ec\ub418\ub294\uc9c0(\uc784\uc2dc \ud14c\uc774\ube14\uc744 \ud1b5\ud55c \ud750\ub984 \ud3ec\ud568)\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <code>\ubcd1\ud569<\/code>\ub610\ud55c \uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \ucd94\uc801\ud558\uc9c0 \uc54a\ub294 \ub3d9\uc801 SQL\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQLFlow\ub294 SQL Server \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc811\uadfc \uad8c\ud55c\uc774 \ud544\uc694\ud55c\uac00\uc694?<\/h3>\n\n\n<p>\uc544\ub2c8\uc694. SQLFlow\ub294 SQL \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc815\uc801 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uba70 \uc120\ud0dd\uc801\uc73c\ub85c \ud14c\uc774\ube14 \ubc0f \ud504\ub85c\uc2dc\uc800 \uc815\uc758\uc640 \uac19\uc740 \uc2a4\ud0a4\ub9c8 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc77d\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud14c\uc774\ube14 \ud589 \ub370\uc774\ud130\ub294 \uc808\ub300 \uc77d\uc9c0 \uc54a\uc73c\uba70, \uc628\ud504\ub808\ubbf8\uc2a4 \ubc84\uc804\uc740 SQL \ud14d\uc2a4\ud2b8\ub97c \ub124\ud2b8\uc6cc\ud06c \ub0b4\ubd80\uc5d0 \ubcf4\uad00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc5b4\ub5a4 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uac00 \uc5b4\ub5a4 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud558\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc608. SQLFlow\ub294 \ud504\ub85c\uc2dc\uc800 \uac04 \ud638\ucd9c\uacfc \uc5f4 \uacc4\ubcf4\ub97c \ud568\uaed8 \ubcf4\uc5ec\uc8fc\ub294 \ub300\ud654\ud615 \ud638\ucd9c \uadf8\ub798\ud504\ub97c \uc81c\uacf5\ud558\ubbc0\ub85c \uc5ec\ub7ec \ud504\ub85c\uc2dc\uc800\ub85c \uad6c\uc131\ub41c ETL \uccb4\uc778\uc744 \ucc98\uc74c\ubd80\ud130 \ub05d\uae4c\uc9c0 \ud0d0\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Server \uacc4\ubcf4 \uae30\ub2a5\uc744 \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcfc \uc218 \uc788\ub294 \ubc29\ubc95\uc774 \uc788\ub098\uc694?<\/h3>\n\n\n<p>\uc608. <a href=\"https:\/\/sqlflow.gudusoft.com\/?utm_source=gudusoft&amp;utm_medium=website&amp;utm_campaign=sql-server-data-lineage\">SQLFlow \ud074\ub77c\uc6b0\ub4dc<\/a> \ubb34\ub8cc \ud2f0\uc5b4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ube0c\ub77c\uc6b0\uc800\uc5d0 T-SQL \ucf54\ub4dc\ub97c \ubd99\uc5ec\ub123\uc73c\uba74 \uc5f4 \uc218\uc900\uc758 \ub370\uc774\ud130 \uacc4\ubcf4\ub3c4\ub97c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud504\ub9ac\ubbf8\uc5c4 \ud2f0\uc5b4\ub294 \ub354 \ub9ce\uc740 \uc785\ub825\uacfc API \uc811\uadfc\uc744 \uc704\ud574 \uc6d4 $49.99\ub2ec\ub7ec\uc785\ub2c8\ub2e4.<\/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\">\uc9c0\uae08 \ubc14\ub85c SQL Server \uacc4\ubcf4\ub97c \ub9e4\ud551\ud558\uc138\uc694<\/h2>\n\n\n<p>\uac00\uc7a5 \ubcf5\uc7a1\ud55c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \ubb34\ub8cc \uc2dc\uac01\ud654 \ub3c4\uad6c\uc5d0 \ubd99\uc5ec\ub123\uac70\ub098, \uc804\uccb4 SQL Server \ud658\uacbd\uc744 \ubd84\uc11d\ud558\ub294 \uac83\uc5d0 \ub300\ud574 \uc800\ud76c\uc5d0\uac8c \ubb38\uc758\ud558\uc2ed\uc2dc\uc624.<\/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\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/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\/ko\/%ec%97%b0%eb%9d%bd%ed%95%98%eb%8b%a4\/\">\uae30\uc5c5\uc6a9 \ub370\ubaa8\ub97c \uc694\uccad\ud558\uc138\uc694<\/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\/ko\/wp-json\/wp\/v2\/pages\/6754"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=6754"}],"version-history":[{"count":0,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/pages\/6754\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=6754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}