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

Cast vs. Convert Expand / Collapse
Author
Message
Posted Friday, March 12, 2010 1:03 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 9,928, Visits: 11,196
CirquedeSQLeil (3/12/2010)
Hah - Paulpatine spinning like the MCP before Tron obliterates it with the disk - oh yeah.

You're getting worse...




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #881547
Posted Friday, March 12, 2010 1:08 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 17,967, Visits: 15,979
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
Hah - Paulpatine spinning like the MCP before Tron obliterates it with the disk - oh yeah.

You're getting worse...


I know. Time for dba.sleep(8)




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #881550
Posted Tuesday, March 30, 2010 8:15 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 9,928, Visits: 11,196
Interesting - and nicely controversial. Thanks.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #892808
Posted Wednesday, March 31, 2010 5:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:45 AM
Points: 7,860, Visits: 9,606
Paul White NZ (3/30/2010)
Interesting - and nicely controversial. Thanks.

I think I preferred your comment three weeks ago - I looked up controversial in my dictionary and it doesn't give "causes a high pitched whining sound" as one of the possible meanings.


Tom
Post #893625
Posted Sunday, July 24, 2011 5:19 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:49 AM
Points: 1,451, Visits: 1,855
Good question, but I beg to differ:
1. The definition of platform is not clear - is platform a version of SQL Server or a version of the hardware or OS?
2. If we say that platform is a version of SQL Server, then the correct answer is that CONVERT has more options when compared to CAST
3. CAST is, internally implemented as CONVERT - Refer my post on the topic here: http://beyondrelational.com/blogs/nakul/archive/2011/07/18/cast-v-s-convert-is-there-a-difference-as-far-as-sql-server-is-concerned-which-is-better.aspx

The question leaves a lot of room for interpretation errors. The answer does not clear out those points either.


Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1147200
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse