select Year(Creation_Date)
from Asset_Creation
where Creation_Date = @Creation_Date
select Year(Creation_Date)
from Asset_Creation
阅读背景：
如何在SQL Server中以YY格式获取年份
来源：互联网
分享到：
