How to print the value with desired text in TSQL using sql server 2005

Question

I need to select a value from my "customers" data table. I faced this question in an interview.

Select cust_Name from customers where cust_Id=5;

This query will result as "Naresh".

However, now I need to print the value as:

Customer Name is Naresh

How to print the value like this?

Answer 1

You can use this following code:

Select 'Customer Name is ' + cust_Name from customers where cust_Id=5;

Or also you can use this:

Declare @CustomerName varchar(50)
Select @CustomerName = cust_Name from customers where cust_Id=5;
Print 'Customer Name is ' + @CustomerName ;

Want to be a SQL expert? Join this SQL Training course by Intellipaat to learn more.