SELECT 'Chandu' + 1 ?

 Posted by Bandi on 6/23/2015 | Category: Sql Server Interview questions | Views: 559 | Points: 40
Select from following answers:
  1. Throws error
  2. 'Chandu'
  3. Chandu
  4. Chandu1
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Sojanya on: 6/26/2015 | Points: 10
Correct answer. The error will be "Conversion failed when converting the varchar value 'Test' to data type int. "
Because here we are trying to concatenate string and integer which is not possible directly in SQL.
Posted by: Chvrsri on: 6/26/2015 | Points: 10
Hello Sojanya,

Thank you for responding. But incase you have some thing else to explain please create a new question in the Interview Section and post the same. So that maximum people gets benefited.

Thanks

Login to post response