My input table looks like:
我的输入表如下:
CREATE TABLE #Products (ProductName VARCHAR(100), StartYear INT, EndYear INT NULL)
INSERT INTO #Products (ProductName, StartYear, EndYear)
VALUES ('football', 2013, null)
,('Eggs', 2010, 2014)
CREATE My input table looks like:
我的输入表如下:
CREATE TABLE #Products (ProductName VARCHAR(100), StartYear INT, EndYear INT NULL)
INSERT INTO #Products (ProductName, StartYear, EndYear)
VALUES ('football', 2013, null)
,('Eggs', 2010, 2014)
CREATE