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 ««12

char to datetime! Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 10:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:20 AM
Points: 1,740, Visits: 6,366
Cliff Jones (8/19/2009)
Mark Horninger (8/19/2009)
Actually, you could do an implicit or explicit conversion....




I agree. That was my first thought as well.


Me too. Since there was no 'either implicit or explicit' option, I got it right by a 50% guess
Post #773706
Posted Wednesday, August 19, 2009 1:32 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
The question doesn't actually ask what the author thinks.

I got it right, but only by trying to outthink the author.

None of the answers given were actually sequitur to the question.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #773866
Posted Thursday, August 20, 2009 6:52 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, May 24, 2013 5:20 AM
Points: 660, Visits: 558
GSquared (8/19/2009)
The question doesn't actually ask what the author thinks.

I got it right, but only by trying to outthink the author.

None of the answers given were actually sequitur to the question.


Exactly what I thought when I was staring at the answers, frustrated that I had to take a wild stab in the dark before being able to post... Unfortunately I wasn't successful in my attempt to outthink the author.


--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams
Post #774163
Posted Monday, August 24, 2009 9:14 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, February 24, 2010 4:10 AM
Points: 1,553, Visits: 2,232
I agree with the last two posts. I got it wrong cause I can't mind read.

I can think of many examples where the cast is not implicit...


----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley


Posting Best Practices
Numbers / Tally Tables

SQL-4-Life
Post #776092
Posted Wednesday, October 28, 2009 2:09 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:08 PM
Points: 8,844, Visits: 9,405
Christopher Stobbs (8/24/2009)
I agree with the last two posts. I got it wrong cause I can't mind read.

I can think of many examples where the cast is not implicit...


Well, I disagree with those two posts and with you. Is the conversion from tinyint to int implicit, explicit, or forbidden? It's implicit. But as far as I can see you are telling me that because it is perfectly valid to write
declare @integer int
declare @octet tinyint
select @octet = 0
select @integer = cast (@octet as int)
the conversion from tinyint to int is explicit. Well, I think that's a very strange point of view.

The descriptions in BOL seem to me quite clear. In fact there's even a nice matrix showing which conversions are implicit, which explicit, and which forbidden. It's been there since SQL 2000. It's still there in SQL 2008 R2. [url=http://msdn.microsoft.com/en-us/library/ms187928%28SQL.105%29.aspx][/url]


Tom
Post #810296
Posted Thursday, October 29, 2009 7:46 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 6:08 AM
Points: 77, Visits: 169
Incidentally I recently created a view around OPENQUERY() - data coming from a linked server. Which may have been not the best way to do what I was doing. But anyway, I thought it could be useful to name and CAST to type the columns of the OPENQUERY results - that is, to express explicitly outside the OPENQUERY term the expected columns. But is that worthwhile, or does it perhaps even create a problem?

I haven't been doing the problems lately because I realised if I pass on one that's too hard it doesn't count in the game, and my score looks better than it is. Like Who Wants to Be a Millionaire, I can look at the question and decide to ignore it and keep what I've got. Maybe the score system should keep count of that. I mean, I also don't want to guess, particularly on a point I don't currently understand but may need to at a later date.
Post #810764
Posted Friday, November 2, 2012 4:20 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 1:45 AM
Points: 616, Visits: 97
Toreador (8/19/2009)
Cliff Jones (8/19/2009)
Mark Horninger (8/19/2009)
Actually, you could do an implicit or explicit conversion....




I agree. That was my first thought as well.


Me too. Since there was no 'either implicit or explicit' option, I got it right by a 50% guess


me 2:)
Post #1380247
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse