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 1234»»»

PARSE 1 Expand / Collapse
Author
Message
Posted Saturday, December 15, 2012 1:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:11 AM
Points: 5,567, Visits: 24,744
Comments posted to this topic are about the item PARSE 1

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 #1396907
Posted Sunday, December 16, 2012 2:02 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 13,252, Visits: 10,135
Very very intesting question. Thanks Ron.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1397021
Posted Sunday, December 16, 2012 3:38 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:01 AM
Points: 1,761, Visits: 2,137
Been a long time since I was this happy to get a QOTD right. It wasn't that hard, but I wasn't sure of the deductive reasoning I was using. Thanks for the challenge Ron.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1397026
Posted Sunday, December 16, 2012 6:12 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 6:26 AM
Points: 1,521, Visits: 3,036
Another good QOD on a new feature of SQL 2012. Thanks, Ron.

BTW, I'm sure some of those who chose wrong answers will want to blame Microsoft for screwing up the BOL examples for TryParse(). Very strange to see that on what turns out to be an easy to understand function once you read the description.
Post #1397046
Posted Sunday, December 16, 2012 9:58 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
Very Good Question Ron!
Keep pouring more of those SS2012 stuff..


~ 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 #1397081
Posted Monday, December 17, 2012 3:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Thomas Abraham (12/16/2012)
Been a long time since I was this happy to get a QOTD right. It wasn't that hard, but I wasn't sure of the deductive reasoning I was using. Thanks for the challenge Ron.


+1 ... punching the air, almost like when I'd seen this weekends NFC East scores, I was.


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1397179
Posted Monday, December 17, 2012 3:21 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, October 11, 2013 12:09 PM
Points: 507, Visits: 265
Hi,

Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.
Post #1397180
Posted Monday, December 17, 2012 3:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 1:45 AM
Points: 2,826, Visits: 3,866
JoseACJr (12/17/2012)
Hi,

Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.

I was also quite surprised to see this answer and would have expected the SELECT to be atomic (either all or nothing). I dont have a 2012 handy so if someone could test this please?


Best Regards,
Chris Büttner
Post #1397186
Posted Monday, December 17, 2012 3:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:30 AM
Points: 78, Visits: 195
Christian Buettner-167247 (12/17/2012)
JoseACJr (12/17/2012)
Hi,

Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.

I was also quite surprised to see this answer and would have expected the SELECT to be atomic (either all or nothing). I dont have a 2012 handy so if someone could test this please?



+2
Ron, can you please remove the confusion.
Post #1397189
Posted Monday, December 17, 2012 4:57 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:42 AM
Points: 58, Visits: 213
Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.


Yep - I thought that too but also do not have 2012 handy to test.

I am also looking for confirmation.
I hate getting things wrong but if I do then I want to learn something!




David Bridge
David Bridge Technology Limited
www.davidbridgetechnology.com
Post #1397200
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse