Timestamps

Question

Timestamps

honza.mf

SSCertifiable

Points: 5519
More actions
May 4, 2013 at 2:08 pm

#273553

Comments posted to this topic are about the item Timestamps

See, understand, learn, try, use efficient
© Dr.Plch

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

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

Any explanation dear author?!! :cool:;-)

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

honza.mf SSCertifiable Points: 5519 More actions · Answer 2

hany.helmy (5/5/2013)
I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!
Any explanation dear author?!! :cool:;-)

Did you run it as a batch or as separate statements? Question is written as a single batch.

See, understand, learn, try, use efficient
© Dr.Plch

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

Nice question for a Monday ... great start to the week

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Evgeny Garaev SSCertifiable Points: 7428 More actions · Answer 4

Author should emphasize that it will be one batch. It will be too many wrong answers.

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 5

I think author did mention it clearly that execute all statement in a single batch.

Due to that i lose my points..:doze:

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

honza.mf SSCertifiable Points: 5519 More actions · Answer 6

Evgeny (5/5/2013)
Author should emphasize that it will be one batch. It will be too many wrong answers.

The question states the batch in the very beggining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

See, understand, learn, try, use efficient
© Dr.Plch

kapil_kk SSC-Insane Points: 21316 More actions · Answer 7

Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..:doze:

Me too lose the points 🙁

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 8

I didn't read question carefully...so lose the question.

Lokesh Vij SSChampion Points: 10836 More actions · Answer 9

I too rushed (over read "batch") and got the question wrong! 🙁

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Lokesh Vij SSChampion Points: 10836 More actions · Answer 10

kapil_kk (5/6/2013)
Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..:doze:
Me too lose the points 🙁

+1 🙁

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 11

Good one, thank you for the Kick Start Post. 🙂

(well... long story short...) "damn!!!..." (where is my "learn sql in 21 hours for beginners" book?)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 12

Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..:doze:

Same goes for me as well.... just lost my valuable points 😎

Carlo Romagnano SSC-Insane Points: 22666 More actions · Answer 13

The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

+1

😀

Good qotd, but too long, it worths 4 points.

honza.mf SSCertifiable Points: 5519 More actions · Answer 14

Carlo Romagnano (5/6/2013)
The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.
+1
😀
Good qotd, but too long, it worths 4 points.

:hehe:

Especially for the majority who answers before first coffee :w00t: