Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 3,348 total)

  • RE: Incremental additions

    da-zero (10/29/2010)

    edit: your explanation comfirms my initial statement that the explanation of the questions' poster is incorrect, as it has nothing to do with pre-increment operators, but with misplacing the...

    October 29, 2010 at 2:48 am

    #1244019

  • RE: Incremental additions

    da-zero (10/29/2010)

    Hardy21 (10/29/2010)

    Thanks for the link. Hence, @a =+ @b-2 means @b-2 value assign to @a so @a = -21.

    Indeed. But why doesn't SQL Server give a syntax error? I...

    October 29, 2010 at 2:22 am

    #1244011

  • RE: Output of Query

    SanDroid (10/28/2010)

    Hugo Kornelis (10/28/2010)

    I wrote that NULL does not represent unknown.

    I understand that is what you wrote.

    I thought maybe you would look at the referenced article before responding.

    Since...

    October 28, 2010 at 4:21 pm

    #1243914

  • RE: Output of Query

    SanDroid (10/28/2010)

    Hugo Kornelis (10/28/2010)

    Good question, but a small (yet significan) mistake in the explanation.

    NULL does not represent the value 'UNKNOWN'.

    Hugo, perhaps you could ask M$ to update the books online...

    October 28, 2010 at 3:05 pm

    #1243855

  • RE: Output of Query

    vk-kirov (10/28/2010)

    Hugo Kornelis (10/28/2010)

    If you use SET ANSI_NULLS OFF, there is no need to rewrite anyway. The ANSI_NULLS affects all comparisons with NULL, not only those in a [NOT] IN...

    October 28, 2010 at 3:14 am

    #1243405

  • RE: Output of Query

    deepak.a (10/27/2010)

    To get the records with NULL value the WHERE condition needs to rewrite as WHERE NullableColumn <> '1' OR NullableColumn IS NULL.

    For the above you can write like this...

    October 28, 2010 at 1:14 am

    #1243367

  • RE: Output of Query

    Good question, but a small (yet significan) mistake in the explanation.

    NULL does not represent the value 'UNKNOWN'. NULL is a marker for a missing value, without any indication as to...

    October 28, 2010 at 1:05 am

    #1243362

  • RE: Variable Array Table

    natalie.ignatieva (10/27/2010)

    As I understand the point of this question is to make us develop skills in typing scripts from the image and don't make errors, right? I failed. Am I...

    October 27, 2010 at 4:30 pm

    #1243233

  • RE: Variable Array Table

    natalie.ignatieva (10/27/2010)

    Management studio shows me this script mostly in black meaning there is something wrong in the script even if it's completed successfully.

    The color coding is actually correct. The first...

    October 27, 2010 at 3:36 pm

    #1243216

  • RE: Date Puzzle

    SanDroid (10/27/2010)

    Hugo Kornelis (10/27/2010)

    And if you ever install SQL Server on a German OS, acccepting all defaults, you'll find that the Server language also defaults to German..

    Is that becuase of...

    October 27, 2010 at 3:32 pm

    #1243215

  • RE: Writing Nearly Codeless Apps: Part 4

    David Ziffer (10/27/2010)

    wbrianwhite (10/27/2010)

    As mundane as this might seem, these three routines provide some dazzling capabilities:

    Not really. A history trigger is a far better choice. The stored proc...

    October 27, 2010 at 11:37 am

    #1243103

  • RE: Date Puzzle

    SanDroid (10/27/2010)

    Hugo,

    What if the client application is submitting the data as XML and thier regional setting is English (Cannada) or some other setting not the same as the SQL server?...

    October 27, 2010 at 11:31 am

    #1243100

  • RE: Date Puzzle

    SanDroid (10/27/2010)

    The Author of this question clearly understood what he was posting and took the time to make sure his question was well worded and that the code worked on...

    October 27, 2010 at 11:29 am

    #1243099

  • RE: Date Puzzle

    SanDroid (10/27/2010)

    da-zero (10/27/2010)

    All I am reading is: easy question = good, difficult question = bad 😉

    I can tell by your reading and writing level you might be the moderator checking...

    October 27, 2010 at 9:12 am

    #1242972

  • RE: Date Puzzle

    Toreador (10/27/2010)

    Hugo Kornelis (10/27/2010)

    For the datetime data type, The only formats that are guaranteed to work correctly in all circumstances are:

    * yyyymmdd - for dates without time portion. No dashes....

    October 27, 2010 at 3:40 am

    #1242723

Viewing 15 posts - 2,521 through 2,535 (of 3,348 total)