September 18, 2013 at 9:33 am
Stewart "Arturius" Campbell (9/18/2013)
Good question, Ron, thanksDidn't even have to bother executing the T-SQL, which is, after all, what this is all about...
Yes... yes it is... I too can claim this one 🙂
September 18, 2013 at 9:48 am
Good question, Ron. It really made me look at the square brackets and field names and think it through before answering.
September 18, 2013 at 10:46 am
Well, and I failed to see something troublesome and answered correctly accidentily...
For me this question was therefore... ...welllll...
________________________________________________________
If you set out to do something, something else must be done first.
September 18, 2013 at 11:23 am
My biggest issue was that I assumed there wasn't more than one answer. I've gotten spoiled by the questions hinting that there is more than one answer.
To be honest, the first time I attempted this on paper I got it correct (I totally suck at basic math in my head... 4 + 4 = 9 right?) but I verified by running it through ssms.
September 18, 2013 at 1:49 pm
You got me, Ron... Thanks anyway!
September 19, 2013 at 12:45 pm
I'm glad to see that a better reference has already been given. Saves me the trouble of looking for it.
An interesting thing (maybe already mentioned in the discussion - I'm a bit short on time) is that deliimiting identifiers with [square brackets] is totally non-standard. As far as I know, only SQL Server and Access support this. The ANSI standard and all complying products use "double quotes" to delimit identifiers.
I think the prime reason for the QUOTED_IDENTIFIER option is to supply backward compatibility. Old versions of SQL Server allowed both "double quotes" and 'single quotes' to delimit string constants, and this was sometimes used to enabl easier specification of string constants that include a single quote / apastrophe (so instead of 'O''Brian', you'd write "O'Brian").
September 24, 2013 at 3:13 am
mtassin (9/18/2013)
Stewart "Arturius" Campbell (9/18/2013)
Good question, Ron, thanksDidn't even have to bother executing the T-SQL, which is, after all, what this is all about...
Yes... yes it is... I too can claim this one 🙂
Ditto
September 25, 2013 at 6:59 am
I picked the correct answer of 5 hours.
But got...
Sorry - you were wrong
Correct answer:
5 hours is returned by the SELECT statement, The create table statement succeeds
September 25, 2013 at 9:40 am
colt (9/25/2013)
I picked the correct answer of 5 hours.But got...
Sorry - you were wrong
Correct answer:
5 hours is returned by the SELECT statement, The create table statement succeeds
The Questions are: This the plural, meaning there is more than a single (1) correct answer. If you only selected one (1) answer when more than one answer was required (requested) you are considered to be wrong.
Does the create table statement fail or succeed?
If the create table statement succeeds what value of TotalHours is returned by the Select statement?
September 25, 2013 at 9:42 am
D'oh. Thanks for the explanation.
September 26, 2013 at 3:35 pm
Nice Question Ron.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 1, 2013 at 3:53 am
very good question. 🙂
October 10, 2013 at 7:25 am
colt (9/25/2013)
I picked the correct answer of 5 hours.But got...
Sorry - you were wrong
Correct answer:
5 hours is returned by the SELECT statement, The create table statement succeeds
same for me.
How can I have a good 'select ....' answer if the 'create table fails' ?
As I could not answer this I checked only one !
Viewing 13 posts - 16 through 27 (of 27 total)
You must be logged in to reply to this topic. Login to reply