SQL Server 2005中的Concat两个字段 [英] Concat two field in sqlserver 2005

问题描述

我正在尝试连接sql中的跟随列.
从tbluser中选择(username +''''+ usertype)as ColumnZ

达成一致之后，这些记录就来了.

I am trying to concat follow column in sql.
select(username + ''''+ usertype) as ColumnZ from tbluser

after concat these record come.

avinashAdmin
manojAdmin
raghuAdmin
anuAdmin

但是我想要在空间中在z列字段结果中显示userfirstname和userlastname
我想要这样的结果:

But i want in space will shown userfirstname and userlastname in column z field result
i want result like:

avinash Admin
manoj Admin
raghu Admin
anu Admin

谢谢.

Thanks.

推荐答案

谢谢您的提问.使用下面的代码.

Thank you for your question. Use bellow code.

select(ISNULL(username,'') + ' ' + ISNULL(usertype,'')) as ColumnZ from tbluser

谢谢，
Mamun

Thanks,
Mamun

您可以通过自定义
的各种方式来使用它

You can use it by various ways by customizing it like

// 1st way
select (username + '' ''+ usertype) as ColumnZ from tbluser

//2nd way
 select(username + '' ''+ usertype) ''ColumnZ''  from tbluser

//3rd way
select ''ColumnZ'' = (username + '' ''+ usertype) from tbluser

:)

:)

使用空格

select(username + '' '' + usertype) as ColumnZ from tbluser

根据您的评论，我认为您正在尝试使用(username + '' '' + usertype) = ''avinash Admin''查找.
然后，我建议将输入拆分为字符串，并匹配用户名和用户类型的各个字段.我认为这样会更好.
[END EDIT]

As per your comment I think you are trying to find using (username + '' '' + usertype) = ''avinash Admin''.
Then I would suggest split the input in strings and match individual fields username and usertype. I think that would be better.
[END EDIT]

这篇关于SQL Server 2005中的Concat两个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！