tsql - 如何使用SQL Server 2005在TSQL中以所需的文本打印值

Question

我想从customers数据表中选择一个值。采访中有人问我这个问题。

Select cust_Name from customers where cust_Id=5;

将结果为 Naresh。

现在我想将值打印为

Customer Name is Naresh

我该如何打印这样的值。谢谢

Answer 1

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

或者

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