SQL Query (View) vs 2008 R2

• javamarket

  Old Hand

  Points: 346

  More actions

  December 21, 2013 at 8:37 am

  #286493

  This is an update of a previous thread that had a SQL Query that was showing anomalies.

  It was discovered that when using the open source utility SQLAzureMW to check for compatibility and publish a db to Azure, some null values were being transposed to a zero ('0') value. This is apparently a default setting in the bcp.exe utility. To override this you can use the -k parameter.

  Reference: http://technet.microsoft.com/en-us/library/ms187887.aspx

  I would like to request an admin change the thread title to:

  SQL 2008 R2 <null> values transposed to zero value with SQLAzureMW (bcp.exe)

  to help those searching for a related problem

• javamarket

  Old Hand

  Points: 346

  More actions

  December 21, 2013 at 9:29 am

  #1675386

  [updated]

• javamarket

  Old Hand

  Points: 346

  More actions

  December 21, 2013 at 10:34 am

  #1675395

  [updated]

• javamarket

  Old Hand

  Points: 346

  More actions

  December 21, 2013 at 10:48 am

  #1675397

  [updated]

• javamarket

  Old Hand

  Points: 346

  More actions

  December 21, 2013 at 5:14 pm

  #1675413

  [updated]

• Jeff Moden

  SSC Guru

  Points: 1004419

  More actions

  December 21, 2013 at 5:50 pm

  #1675414

  I know no one came to your rescue but I sure do appreciate the "log" of the problem. It'll help other folks, I'm sure.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)