Home Forums SQL Server 2005 SQL Server 2005 Integration Services SQL Server Interview Questions And Answers RE: SQL Server Interview Questions And Answers
SQLSmasher
Right there with Babe
Points: 777
More actions
February 10, 2011 at 7:30 am
#1285173
It is quite good question for initial telephonic interview. And you can give simple answer by
1. CONVERT is SQL speicific but CAST is ANSI standarised
2. CONVERT deal nicely with datetime using format, which is missing from CAST