bcp \uc720\ud2f8\ub9ac\ud2f0\ub294 Microsoft SQL Server 2005 \uc778\uc2a4\ud134\uc2a4\uc640 \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud55c \ud615\uc2dd\uc758 \ub370\uc774\ud130 \ud30c\uc77c \uac04\uc5d0 \ub370\uc774\ud130\ub97c \ub300\ub7c9 \ubcf5\uc0ac\ud569\ub2c8\ub2e4. bcp \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub9ce\uc740 \uc218\uc758 \uc0c8 \ud589\uc744 SQL Server \ud14c\uc774\ube14\ub85c \uac00\uc838\uc624\uac70\ub098 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130 \ud30c\uc77c\ub85c \ub370\uc774\ud130\ub97c \ub0b4\ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4. queryout \uc635\uc158\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\ub97c \uc81c\uc678\ud558\uace0 \uc774 \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud558\ub294 \ub370 Transact-SQL\uc5d0 \ub300\ud55c \uc9c0\uc2dd\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\ub85c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub824\uba74 \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 \ub9cc\ub4e0 \uc11c\uc2dd \ud30c\uc77c\uc744 \uc0ac\uc6a9\ud558\uac70\ub098 \uc774 \ud14c\uc774\ube14\uc758 \uc5f4\uc5d0 \uc801\ud569\ud55c \ud14c\uc774\ube14 \uad6c\uc870\uc640 \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ucc38\uc870 : http:\/\/blog.daum.net\/mindus\/15690534<\/a><\/p>\n \ucc38\uc870 :\u00a0http:\/\/www.sqlteam.com\/article\/exporting-data-programatically-with-bcp-and-xp_cmdshell<\/a><\/p>\n DECLARE @FileName varchar(50), SET @FileName = REPLACE(‘c:\\authors_’+CONVERT(char(8),GETDATE(),1)+’.txt’,’\/’,’-‘) bcp \uc720\ud2f8\ub9ac\ud2f0\ub294 Microsoft SQL Server 2005 \uc778\uc2a4\ud134\uc2a4\uc640 \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud55c \ud615\uc2dd\uc758 \ub370\uc774\ud130 \ud30c\uc77c \uac04\uc5d0 \ub370\uc774\ud130\ub97c \ub300\ub7c9 \ubcf5\uc0ac\ud569\ub2c8\ub2e4. bcp \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub9ce\uc740 \uc218\uc758 \uc0c8 \ud589\uc744 SQL Server […]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[30],"tags":[],"class_list":["post-2774","post","type-post","status-publish","format-standard","hentry","category-windows2008-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2774"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2774\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\u00a0<\/code><\/p>\n
\n@bcpCommand varchar(2000)<\/p>\n
\nSET @bcpCommand = ‘bcp “SELECT TOP 100 * FROM [nix].[dbo].[SALESE]” queryout “‘
\nSET @bcpCommand = @bcpCommand + @FileName + ‘” -U A03 -P a03 -c’
\nEXEC master..xp_cmdshell @bcpCommand<\/p>\n\u00a0<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"