如何在sqlserver查询中给出单个空格

问题描述

嗨frnds，



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



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



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



选择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...

解决方案

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