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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Saturday, August 30, 2014 4:20 PM
Points: 11,194, Visits: 11,142
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:02 PM
Points: 21,657, Visits: 15,326
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #881550
Posted Tuesday, March 30, 2010 8:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Saturday, August 30, 2014 4:20 PM
Points: 11,194, Visits: 11,142
Interesting - and nicely controversial. Thanks.



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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 5:59 PM
Points: 8,748, Visits: 9,296
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 1,415, Visits: 1,831
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
Posted Monday, June 16, 2014 7:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:37 PM
Points: 2,677, Visits: 215
I like going over these old questions and reminding myself how it all works.
Post #1581134
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse