Post reply

BCP results

  • July 26, 2014 at 11:54 pm

    #397123

    Comments posted to this topic are about the item BCP results

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • July 27, 2014 at 4:35 am

    #1732651

    Nice one , thanks

  • July 27, 2014 at 11:18 pm

    #1732697

    I am sorry, but I don't agree 🙂

    I executed the script in SSMS (SQL Server 2012). It returned "10 row(s) affected", the csv file was created, but was empty. If there is any explanation...

  • July 28, 2014 at 12:59 am

    #1732704

    I did not agree,

    because BCP creates an empty file, even it it reports the error.

    I try to execute in a cmd Shell:

    bcp "SELECT EmployeeName FROM #Employee WHERE UniqueId <= 7" queryout "C:\Exports\data.csv" -c -T

    and bcp created an empty file.

  • July 28, 2014 at 1:39 am

    #1732715

    Your question is version specific. From SQL Server 2012 the file will be created.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • July 28, 2014 at 1:50 am

    #1732717

    i have checked it on MSSQL 2012. :crying:

  • July 28, 2014 at 2:45 am

    This was removed by the editor as SPAM

  • July 28, 2014 at 3:15 am

    #1732734

    Stewart "Arturius" Campbell (7/28/2014)

    Sean Pearce (7/28/2014)

    Your question is version specific. From SQL Server 2012 the file will be created.

    +1

    All in all, a good question, despite missing the specification regarding SQL Server version...

    My bad - apologies to all affected

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • July 28, 2014 at 3:33 am

    #1732736

    Got it wrong 🙁

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
     🙂

  • July 28, 2014 at 4:40 am

    #1732744

    rhythmk (7/28/2014)

    Got it wrong 🙁

    Same here but it`s because of the bad design of the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • July 28, 2014 at 4:53 am

    #1732747

    Roland C (7/27/2014)

    I am sorry, but I don't agree 🙂

    I executed the script in SSMS (SQL Server 2012). It returned "10 row(s) affected", the csv file was created, but was empty. If there is any explanation...

    The same 10 rows result I got, unfortunately the author didn`t explain that version issue in the question :w00t:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • July 28, 2014 at 4:56 am

    #1732749

    Stuart Davies (7/28/2014)

    Stewart "Arturius" Campbell (7/28/2014)

    Sean Pearce (7/28/2014)

    Your question is version specific. From SQL Server 2012 the file will be created.

    +1

    All in all, a good question, despite missing the specification regarding SQL Server version...

    My bad - apologies to all affected

    We have a rule here in QoTD, that we are running the latest SQL Server version by default unless other mentioned in the question literally, so we all need our 2 points back man 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • July 28, 2014 at 5:16 am

    #1732762

    Sean Pearce (7/28/2014)

    Your question is version specific. From SQL Server 2012 the file will be created.

    Thanks Sean for providing a much better explanation

    Using 2012, I had empty file

    +1

  • July 28, 2014 at 5:17 am

    #1732763

    Author should mention the SQL Server version. Agree with all

    Thanks

  • July 28, 2014 at 5:50 am

    #1732776

    I'm lucky that we're still running 2008. 😛 Thanks for sharing the question.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply