Altering Included Indexes
-
Comments posted to this topic are about the item Altering Included Indexes
-
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] -
"ALTER TABLE dbo.MySales ALTER COLUMN orderstatus VARCHAR(20); GO "
How this is the valid? There is no such a column present in table.
-
Correct answers 12%.
At least I'm in the majority!
-
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.
-
Dooooh! Picked the right one, plus guessed wrong for the wrong "right" answer, picked #3.
-
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 -
I guess Steve meant OrderNotes instead orderstatus.
-
Option 4 does not work as there is no orderstatus column.
Should have been ADD instead of ALTER COLUMN
-
I bin robbed!:crying:
-
Option 4 failed as there is no column orderstatus in table MySales:alien:
-
+1
-
Option 4 :w00t:
-
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...
-
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