SELECT 'Chandu' + 1 ?

Posted by Bandi on 6/23/2015 | Category: Sql Server Interview questions | Views: 2573 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Select from following answers:

Throws error
'Chandu'
Chandu
Chandu1
All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : SELECT COUNT('7') ?

Next > : SELECT 'Chandu' + ‘1’ ?

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

More Interview Questions by Bandi

Latest Interview Questions