Create a stored procedure

Question

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

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

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 2

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 3

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

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

RK Mandava

SSCarpal Tunnel

Points: 4153

October 15, 2014 at 9:19 am

#1752595

+1

George Vobr SSChampion Points: 10074 More actions · Answer 5

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 6

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 7

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: 182947 More actions · Answer 8

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: 2687 More actions · Answer 9

+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 10

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

Mauricio_ SSCrazy Points: 2935 More actions · Answer 11

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 12

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: 738112 More actions · Answer 13

Steve Jones - SSC Editor

SSC Guru

Points: 738112

October 16, 2014 at 8:52 am

#1752893

Question is corrected and points awarded back

rambids999 SSC Enthusiast Points: 135 More actions · Answer 14

rambids999

SSC Enthusiast

Points: 135

October 17, 2014 at 12:51 am

#1753036

comments added to the topic

Gavin Regnart Old Hand Points: 303 More actions · Answer 15

Steve Jones - SSC Editor (10/16/2014)
Question is corrected and points awarded back

Which explains (1) why the query ran without a problem for me, and (2) why there is a 97% correct answer statistic.

Sometimes it pays to be late to the party! :w00t:

Create a stored procedure

Cookies on SQLServerCentral