SELECT convert(varchar(10),playerid_1) + '_' + convert(varchar(10),playerid_2)
from [Game_Main].[dbo].[ab_niuniu_club_record]
where date_time<'2017-12-06 14:05:55.000'
sqlserver 拼接字段
于 2018-06-15 16:34:08 首次发布
SELECT convert(varchar(10),playerid_1) + '_' + convert(varchar(10),playerid_2)
from [Game_Main].[dbo].[ab_niuniu_club_record]
where date_time<'2017-12-06 14:05:55.000'