Post reply

Altering Included Indexes

  • December 29, 2015 at 9:54 pm

    #74801

    Comments posted to this topic are about the item Altering Included Indexes

  • December 29, 2015 at 10:00 pm

    #1848679

    ALTER TABLE dbo.MySales ALTER COLUMN orderstatus VARCHAR(20);

    OPTION 4 will fail as there is no such column in the table.

    [font="Calibri"]Raj[/font]

  • December 30, 2015 at 12:17 am

    #1848684

    "ALTER TABLE dbo.MySales ALTER COLUMN orderstatus VARCHAR(20); GO "

    How this is the valid? There is no such a column present in table.

  • December 30, 2015 at 1:36 am

    #1848689

    Correct answers 12%.

    At least I'm in the majority!

  • December 30, 2015 at 2:30 am

    #1848690

    I think there was some kind of mistake really, there is no other option beside Option 4 and the column is not available in table. I was unable to answer the question. Steve i think you need to check this QotD.

  • December 30, 2015 at 2:41 am

    #1848693

    Dooooh! Picked the right one, plus guessed wrong for the wrong "right" answer, picked #3.

  • December 30, 2015 at 2:48 am

    #1848695

    dfine (12/29/2015)

    ALTER TABLE dbo.MySales ALTER COLUMN orderstatus VARCHAR(20);

    OPTION 4 will fail as there is no such column in the table.

    +1

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • December 30, 2015 at 3:23 am

    #1848699

    I guess Steve meant OrderNotes instead orderstatus.

  • December 30, 2015 at 4:05 am

    #1848700

    Option 4 does not work as there is no orderstatus column.

    Should have been ADD instead of ALTER COLUMN

    😉

  • December 30, 2015 at 5:14 am

    #1848706

    I bin robbed!:crying:

  • December 30, 2015 at 5:20 am

    #1848707

    Option 4 failed as there is no column orderstatus in table MySales:alien:

  • December 30, 2015 at 5:47 am

    #1848713

    +1

  • December 30, 2015 at 5:55 am

    #1848715

    Option 4 :w00t:

  • December 30, 2015 at 6:29 am

    #1848722

    I just confirmed this by attempting to do a an "alter column" on a column that does not exist in a table.

    As expected, I got the following error: "Msg 4924, Level 16, State 1, Line 4

    ALTER TABLE ALTER COLUMN failed because column 'orderstatus' does not exist in table 'Weld Side Final'."

    Glad I wasn't the only one who was given a "wrong" on a "Right" answer...

  • December 30, 2015 at 6:33 am

    #1848725

    Answer 4 is NOT as correct answer as that column doesn't exist. 🙂

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

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