在 SQL Server 视图中使用默认值创建新列

Question

我对视图有这个查询：

SELECT t1.Connected, t1.Region, t1.Homespassed 
FROM connected as t1 
UNION ALL 
SELECT t2.Connected, t2.Region, t2.Homespassed 
FROM connected as t2

我想添加一个具有默认年份值的新列。该表应如下所示：

Connected | Region | Homespassed | Year

我们正在成立工会的每种观点都有不同的年份。请协助

Answer 1

好的，根据您的评论，您有一个常量值作为您的年份，因此这将解决问题：

SELECT t1.Connected, t1.Region, t1.Homespassed, '2017' as Year FROM connected as t1 
UNION ALL 
SELECT t2.Connected, t2.Region, t2.Homespassed, '2018' as Year FROM connected as t2;

或者，如果您希望代码更好一些：

DECLARE @YEAR1 CHAR(4), @YEAR2 CHAR(4);
SET @YEAR1 = '2017';
SET @YEAR2 = '2018';
SELECT t1.Connected, t1.Region, t1.Homespassed, @YEAR1 as Year FROM connected as t1 
UNION ALL 
SELECT t2.Connected, t2.Region, t2.Homespassed, @YEAR2 as Year FROM connected as t2;