对于字符类型的字段可以用'+'号连接输出
SELECT ([UserName]+'-'+[Sex]) AS 'NewColumn' FROM [Users];
如果其中有不是字符类型的字段,比如字符类型与数值类型拼接,则需要对数值类型字段进行转换
SELECT ([UserName]+'-'+CONVERT([nvarchar](50),[Sex])) AS 'NewColumn' FROM [Users];
对于字符类型的字段可以用'+'号连接输出
SELECT ([UserName]+'-'+[Sex]) AS 'NewColumn' FROM [Users];
SELECT ([UserName]+'-'+CONVERT([nvarchar](50),[Sex])) AS 'NewColumn' FROM [Users];