메뉴 닫기

MSSQL 쿼리로 CSV 파일 데이터 업로드 하는 방법 ( BULK INSERT )

SSMS 에서 쿼리로 CSV 파일 데이터 업로드 하는 방법입니다.
2005 부터 가능합니다.

BEGIN TRANSACTION
--DROP TABLE CSVable
CREATE TABLE CSVable
    (
co1 nvarchar(4000) NULL,
        co2 nvarchar(4000) NULL
)
BULK INSERT CSVable
FROM
    'c:\test.csv'
WITH
    (
        fieldterminator = ',',  -- 열 구분자
        rowterminator = '\n',   -- 행 구분자
        firstrow = 1        --시작 행의 Index를 지정
    )
SELECT * FROM CSVable WITH(NOLOCK)
    --ROLLBACK TRANSACTION
COMMIT TRANSACTION

40 Comments

  1. g rsacwgxy

    I am really loving the theme/design of your web site. Do you ever run into any web browser compatibility issues?
    A number of my blog visitors have complained about my blog
    not working correctly in Explorer but looks great in Chrome.

    Do you have any suggestions to help fix this problem?

  2. cbd oil that works 2020

    I absolutely love your blog and find most of your post’s to be exactly
    what I’m looking for. Do you offer guest writers to
    write content in your case? I wouldn’t mind composing a post or
    elaborating on a number of the subjects you write
    in relation to here. Again, awesome website!

  3. Charmaine Juell

    I simply want to mention I am newbie to blogging and site-building and actually loved this blog. More than likely I’m going to bookmark your blog post . You really have wonderful well written articles. Regards for sharing your blog site.

  4. buy viagra

    Aw, this was a really great post. In concept I want to put in creating similar to this additionally? taking time and real initiative to make a great short article? but what can I claim? I hesitate alot and never seem to obtain something done.

  5. CBD Cream

    Good site! I really love how it is simple on my eyes and the data are well written. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your RSS which must do the trick! Have a great day!

  6. useful source

    I?m satisfied, I need to claim. Actually rarely do I run into a blog site that?s both enlightening and amusing, as well as let me tell you, you have actually struck the nail on the head. Your suggestion is superior; the problem is something that not nearly enough people are talking smartly around. I am extremely delighted that I stumbled across this in my look for something associating with this.

  7. cbd oils for collapsed trachea in dogs

    There are definitely a lot of details like that to think about. That is a wonderful indicate bring up. I supply the thoughts over as basic motivation however clearly there are inquiries like the one you bring up where one of the most essential thing will certainly be working in truthful good faith. I don?t know if ideal techniques have arised around points like that, but I make sure that your work is plainly identified as a level playing field. Both children and also girls really feel the impact of simply a moment?s pleasure, for the remainder of their lives.

  8. are cbd dog treats in wi

    There are some interesting points in time in this write-up yet I don?t know if I see every one of them facility to heart. There is some validity however I will certainly hold point of view till I explore it even more. Good short article, thanks and also we want extra! Contributed to FeedBurner too

  9. cbd capsules

    There are definitely a lot of details like that to think about. That is an excellent point to bring up. I provide the ideas above as basic inspiration yet clearly there are inquiries like the one you raise where one of the most vital point will be working in straightforward good faith. I don?t recognize if finest practices have actually arised around points like that, but I make certain that your job is clearly determined as a level playing field. Both boys and women really feel the impact of simply a moment?s enjoyment, for the rest of their lives.

  10. check out the post right here

    After study a few of the blog posts on your web site now, and I genuinely like your method of blog writing. I bookmarked it to my book marking internet site checklist as well as will certainly be inspecting back soon. Pls look into my web site as well as well as let me know what you think.

  11. his explanation

    I found your blog site on google and inspect a few of your very early messages. Continue to keep up the very good operate. I simply added up your RSS feed to my MSN News Reader. Looking for onward to reading more from you later!?

  12. Google

    Hello there! This post could not be written any better! Going through this article reminds me of my previous roommate! He always kept talking about this. I most certainly will send this information to him. Pretty sure he will have a good read. Thank you for sharing!

  13. Audra Graner

    I found your blog website on google and examine a few of your very early articles. Continue to maintain the great run. I just additional up your RSS feed to my MSN Information Visitor. Looking for ahead to learning more from you later on!?

  14. go to these guys

    The following time I read a blog, I really hope that it does not disappoint me as high as this. I indicate, I know it was my option to review, however I in fact assumed youd have something interesting to state. All I hear is a lot of whimpering regarding something that you might take care of if you werent also hectic trying to find focus.

  15. Web Site

    Can I simply say what a relief to discover someone who actually understands what theyre talking about on the net. You most definitely recognize exactly how to bring a problem to light as well as make it vital. More individuals need to read this and also understand this side of the tale. I cant think youre not extra popular because you most definitely have the gift.

  16. our website

    After study a few of the post on your website now, and also I absolutely like your means of blog writing. I bookmarked it to my book marking site checklist and will be examining back soon. Pls look into my web site as well and also let me understand what you assume.

댓글 남기기

이메일은 공개되지 않습니다.