sql-server - SQL Server 2008 : Fill multiple T-SQL variables from one SELECT query?

Question

要使用查询中的值填充一个变量，我可以编写以下内容:

SET @TargetID = (SELECT TOP 1 ID FROM @bigDataSet ORDER BY date DESC)

从该查询中填充多个变量，例如。像这样:

SET (@TargetID, @TargetName) = ....(SELECT TOP 1 ID, [Name] FROM @bigDataSet ORDER BY date DESC)

我可以写什么？

Answer 1

SELECT TOP (1) @TargetID=ID, @TargetName=Name 
FROM @bigDataSet 
ORDER BY date DESC