Forum Replies Created

Viewing 6 posts - 1 through 7 (of 7 total)

  • RE: SSIS w/Identity column

    Chris Harshman - Wednesday, April 19, 2017 1:50 PM

    This would depend on a number of things, if you TRUNCATE the table before...

  • RE: Identity Column

    Lynn Pettis - Monday, April 3, 2017 3:00 PM

    mcampoam - Monday, April 3, 2017 2:39 PM

  • RE: Identity Column

    Michael L John - Monday, April 3, 2017 2:25 PM

    The second question is school id.  
    Will the student id be the same...

  • RE: Identity Column

    sgmunson - Monday, April 3, 2017 1:56 PM

    Michael L John - Monday, April 3, 2017 1:15 PM

  • RE: Identity Column

    Thank Lynn,

    Yes the student id would be unique. Actually one more column would be part of the key "School Id' since a student can have multiple enrollmments.

  • RE: Is there any difference between the 2

    ChrisM@Work (10/12/2016)


    Both methods will fare poorly against the more natural way of writing this statement:

    -- read the table only once

    UPDATE Customer SET column_1 = CASE

    WHEN column_2 IS NULL AND column_3...

Viewing 6 posts - 1 through 7 (of 7 total)