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

Question

I want to select a value from my customers datatable. I have been asked this question in an interview.

Select cust_Name from customers where cust_Id=5;

will result as Naresh.

Now I want to print the value as

Customer Name is Naresh

How can I print the value like this.Thank you

Shahid Iqbal · Accepted Answer · 2013-05-15 04:34:54Z

16

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

Or

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

answered May 15, 2013 at 4:29

Shahid Iqbal

2,1339 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thought that there will some statement like print :)

Thanks for showing two different ways in printing statement in SQL.

user1982736 · Accepted Answer · 2013-05-15 04:42:13Z

2

You can declare them

Declare @CstName nvarchar(100)
Select @CstName = cust_Name from customers where cust_Id=5;
Print 'Customer Name is ' + @CstName ;

This is the bettre way while using TSQL as you asked

answered May 15, 2013 at 4:42

user1982736

Ishaan007 · Accepted Answer · 2019-08-05 09:30:16Z

2

You can use concat()

Select concat('Customer Name is',cust_Name) as values from customers where cust_Id=5;

answered Aug 5, 2019 at 9:30

Ishaan007

1259 bronze badges