Create a stored procedure

Question

Post reply

Create a stored procedure

Viewing 15 posts - 46 through 60 (of 64 total)

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

Bobby Russell SSCrazy Points: 2801 More actions · Answer 1

The correct answer is NONE OF THE ABOVE. If you don't bracket the reserved word column you are going to get:

Msg 156, Level 15, State 1, Procedure my_sp, Line 2

Incorrect syntax near the keyword 'FROM'.

Which CLEARLY falls under the answer NONE OF THE ABOVE.

j-squared SSC-Addicted Points: 407 More actions · Answer 2

I thought it was a trick question because the "none of the above" answer was provided, and "column" (without quotes) is a syntax error, not a valid column name. So I selected the "none of the above" answer and got the question wrong.

Boo!

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 3

Given answer is wrong, Sql server will give error on given procedure.

because "Column" is a reserved keyword and needs to be delimited if you want to use it as a column (e.g. [Column]).

abjames Old Hand Points: 340 More actions · Answer 4

Me three... or four... or however many people have already responded...

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 5

RK Mandava

SSCarpal Tunnel

Points: 4153

October 15, 2014 at 9:19 am

#1752595

+1

George Vobr SSChampion Points: 10008 More actions · Answer 6

I will get an error like this: Server: Msg 208, Level 16, State 1, Procedure my_sp, Line 2 Invalid object name 'my_table'.

Stephanie J Brown Hall of Fame Points: 3896 More actions · Answer 7

Even with COLUMN instead of COLUMNS, this was a good question - just look at the spread of percentages on each of the five answers.

Hoping to see more from Jamie - with final testing included. 😀

"Would everyone who has never made a mistake please raise their hands."

Here there be dragons...,

Steph Brown

dhans123 SSCommitted Points: 1766 More actions · Answer 8

I also got error

Msg 156, Level 15, State 1, Procedure my_sp, Line 2

Incorrect syntax near the keyword 'FROM'.

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 9

dhans123 (10/15/2014)
I also got error
Msg 156, Level 15, State 1, Procedure my_sp, Line 2
Incorrect syntax near the keyword 'FROM'.

Thanks for the question:-)

Got the same on 2014, non of the options are correct, maybe different settings?

On my system, this works

CREATE PROCEDURE my_sp AS

SELECT [column] FROM my_table

😎

matt.bowler SSCrazy Points: 2677 More actions · Answer 10

+1 to all the comments that pointed out the answer is incorrect. Good question to examine the defered name resolution idea - but need to verify code? Made it ambiguous what was intended.

gyan_119 SSC Rookie Points: 28 More actions · Answer 11

Can anyone tell when column name given as "ID", why is not giving error?

Mauricio_ SSCrazy Points: 2935 More actions · Answer 12

gyan_119 (10/15/2014)
Can anyone tell when column name given as "ID", why is not giving error?

Because ID is not a reserved word as column. If you want to use SELECT column FROM MyTable you need to do it like this: SELECT [column] FROM MyTable.

IanSinclair SSCertifiable Points: 6132 More actions · Answer 13

As many people have said - the correct answer to the question asked was 'None of the above'.

Nit picking would apply if the correct answer was below 'None of the above' in the list and you were to argue that 'None of the above' still applied

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 14

Steve Jones - SSC Editor

SSC Guru

Points: 736478

October 16, 2014 at 8:52 am

#1752893

Question is corrected and points awarded back

rambids999 SSC Enthusiast Points: 135 More actions · Answer 15

rambids999

SSC Enthusiast

Points: 135

October 17, 2014 at 12:51 am

#1753036

comments added to the topic