We have a table named 'Customer' which has a column named 'Customerid' having datatype Integer. We need to fetch the output with column title: 'Customer id is (value of customerid from the table)'. What will be the query? - Microsoft SQL Server

> > >

Microsoft SQL Server MCQs

We have a table named "Customer" which has a column named "Customerid" having datatype Integer. We need to fetch the output with column title: 'Customer id is (value of customerid from the table)'. What will be the query?

Select 'Customer id is' + customerid From Customer

Select 'Customer id is' + CAST(customerid AS varchar) From Customer

Select 'Customer id is' + CAST(customerid AS integer) From Customer

Both a and b

None of these

Answer

Correct Answer: Select 'Customer id is' + CAST(customerid AS varchar) From Customer

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it