when to use cast and when to use convert operator in SQL

Published by: Rinku (10/25/2008 1:16:01 AM)

I always get confused with this. Can anyone explain with an example when to use a cast operator and when to use Convert operator for writing SQL Querries. What is the difference between cast and convert operators when they are both used to change one data type to another data type. Also please explain which one is better for faster query processing.

 

Most Popular Articles

• How can I run my Stored Procedure in SQL Server 2005
• SQL Join Query for Microsoft Access Database
• What is the use of nolock condition in SQL Query
• How can I Truncate my Database Log to Reduce the Size
• when to use cast and when to use convert operator in SQL

What is the Difference between Inner Join and Join >>

<< What is the use of nolock condition in SQL Query