Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Timestamps Expand / Collapse
Author
Message
Posted Saturday, May 4, 2013 2:08 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 1:20 AM
Points: 1,387, Visits: 1,315
Comments posted to this topic are about the item Timestamps



See, understand, learn, try, use efficient
© Dr.Plch
Post #1449463
Posted Sunday, May 5, 2013 1:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:44 AM
Points: 1,313, Visits: 626
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?!!
Post #1449500
Posted Sunday, May 5, 2013 11:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 1:20 AM
Points: 1,387, Visits: 1,315
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?!!

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
Post #1449529
Posted Sunday, May 5, 2013 6:12 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
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

Before posting a performance problem please read
Post #1449552
Posted Sunday, May 5, 2013 10:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:45 AM
Points: 1,104, Visits: 696
Author should emphasize that it will be one batch. It will be too many wrong answers.
Post #1449581
Posted Sunday, May 5, 2013 11:26 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1449585
Posted Sunday, May 5, 2013 11:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 1:20 AM
Points: 1,387, Visits: 1,315
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
Post #1449587
Posted Monday, May 6, 2013 12:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:54 AM
Points: 1,921, Visits: 2,345
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..

Me too lose the points



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1449590
Posted Monday, May 6, 2013 12:22 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Sunday, October 12, 2014 11:25 PM
Points: 717, Visits: 938
I didn't read question carefully...so lose the question.
Post #1449591
Posted Monday, May 6, 2013 12:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:02 AM
Points: 1,372, Visits: 1,566
I too rushed (over read "batch") and got the question wrong!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1449592
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse