Cast vs. Convert

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Prakriti Agrawal » Cast vs. Convert

35 posts, Page 4 of 4

«««1 2 3 4

Cast vs. Convert

Rate Topic

Display Mode

Topic Options

Author

Message

Paul White

Posted Friday, March 12, 2010 1:03 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 10,990, Visits: 10,578

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

SQLRNNR

Posted Friday, March 12, 2010 1:08 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:31 AM
Points: 18,857, Visits: 12,442

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 2008

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

Paul White

Posted Tuesday, March 30, 2010 8:15 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 10,990, Visits: 10,578

Interesting - and nicely controversial. Thanks.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #892808

L' Eomot Inversé

Posted Wednesday, March 31, 2010 5:02 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 7,185, Visits: 7,285

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
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

http://es.linkedin.com/in/tomthomsonsoftware

Post #893625

Nakul Vachhrajani

Posted Sunday, July 24, 2011 5:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:56 AM
Points: 1,282, Visits: 1,613

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://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1147200

« Prev Topic | Next Topic »

35 posts, Page 4 of 4

«««1 2 3 4

Permissions