使用以下内容：

 选择 转换（ nvarchar  （ 50 ），ID）+ '   - ' + Convert（ nvarchar （ 50 ），年） as  ID_Year 来自 tablename 

还可以尝试

  SELECT （ID +    -  + year） AS  ID_Year 
 FROM  tablename 

你可以像以下一样使用Sql Query： -



select cast（id as varchar）+' - '+ cast（year as varchar）as ID_year



希望，这会对你有所帮助...

Ho to concatenate two columns in SQL Server 2008.

Example Below
-------------

ID(int)     Year(int)     
-------     ---------
10           2008
20           2009
30           2010

Output should come as below

ID_Year (Output)
-------
10-2008
20-2009
30-2010

How to query in SQL Server 2008.

Use the following :

select Convert(nvarchar(50),ID)+'-'+Convert(nvarchar(50),Year) as ID_Year from tablename

Try also

SELECT (ID + '-' + year) AS ID_Year
FROM tablename

u can use Sql Query like:-

select cast(id as varchar)+'-'+ cast(year as varchar) as ID_year

Hope, this will help you...