如何在数据库查询中连接名字和姓氏 [英] How can I concat first and last name in database query

问题描述

我想在mssql中调整以下查询，以获取FirstName和Lastname列以在表中自动填充Fullname列。我寻求你的帮助。在此先感谢



使用[EXEXORESULTS]

GO



SELECT [竞争对手]

，[FirstName]

，[LastName]

，[DOB]

，[机构]

，[CompetitiveEventName]

，[ParishName]

，[年]

，[FullName]

来自[dbo]。[竞争对手]

GO





示例 - - firstname = John Lastname = Brown Fullname = John Brown（有空格）



我尝试过：



使用数据库查询concat first和lastname

I would like to adjust the below query in mssql to get FirstName and Lastname columns to populate Fullname column automatically in the table. I seek your assistance. Thanks in advance

USE [EXPRORESULTS]
GO

SELECT [CompetitorID]
,[FirstName]
,[LastName]
,[DOB]
,[Institution]
,[CompetitiveEventName]
,[ParishName]
,[Year]
,[FullName]
FROM [dbo].[Competitors]
GO


example --- firstname = John Lastname =Brown Fullname= John Brown (with space)

What I have tried:

concat first and lastname using database query

推荐答案

请参阅：例如： Mysql - 如何使用另一列的值加上一些字符串来更新列 - Stack Overflow [ ^ ]。

See, for instance: Mysql - How to update a column using another column's value plus some strings - Stack Overflow[^].

这篇关于如何在数据库查询中连接名字和姓氏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！