如何在sqlserver查询中给出单个空格 [英] How to give a single space in sqlserver query

问题描述

嗨frnds，



正在处理gridview数据从Sqlserver数据库显示。



我我希望在列中留出空间。



根据我的代码和查询，它是



选择FL_Name为FullName，Fn_Name AS FirstName，Ln_Name AS姓氏来自Emp



但是我需要空间，它必须像这个全名，名字，姓氏。



请帮助我，如何在单栏之间留出空间。



谢谢...

解决方案

尝试这个，它会有所帮助......

 选择 FL_Name 为  全名 ，Fn_Name  AS   名字，Ln_Name  AS   姓氏 来自 Emp 

; - ）

尝试：

  SELECT  FL_Name  AS  [完整名称]，Fn_Name  AS  [名字]，Ln_Name  AS  [姓氏]  FROM  Emp 

尝试选择FL_Name作为FullName，''，Fn_Name AS FirstName，''，Ln_Name AS姓氏来自Emp

hi frnds,

am working on gridview data is displaying from Sqlserver database.

I want to give space in column.

According to my Code and query it is

Select FL_Name as FullName,Fn_Name AS FirstName,Ln_Name AS LastName from Emp

But i need space, it must be like this Full Name, First Name, Last Name.

Please can you help me, how to give space in between single column.

Thanks...

解决方案

try this one, it would be helpful...

Select FL_Name as "Full Name",Fn_Name AS "First Name",Ln_Name AS "Last Name" from Emp

;-)

Try:

SELECT FL_Name AS [Full Name],Fn_Name AS [First Name],Ln_Name AS [Last Name] FROM Emp

Try Select FL_Name as FullName ,' ' , Fn_Name AS FirstName,' ', Ln_Name AS LastName from Emp

这篇关于如何在sqlserver查询中给出单个空格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！