本文介绍了在一个 SELECT 语句中设置两个标量变量?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想这样做:
Declare @a int;
Declare @b int;
SET @a,@b = (SELECT StartNum,EndNum FROM Users Where UserId = '1223')
PRINT @a
PRINT @b
但这是无效的语法.如何在一个 select 语句中设置多个标量变量?我可以:
But this is invalid syntax. How do I set multiple scalar variables in one select statement? I can do:
Declare @a int;
Declare @b int;
SET @a = (SELECT StartNum FROM Users Where UserId = '1223')
SET @b = (SELECT EndNum FROM Users Where UserId = '1223')
PRINT @a
PRINT @b
但这需要两倍的时间.最快的方法是什么?
But this will take twice as long. What is the fastest way?
推荐答案
DECLARE @a int;
DECLARE @b int;
SELECT @a = StartNum, @b = EndNum
FROM Users
WHERE UserId = '1223'
这篇关于在一个 SELECT 语句中设置两个标量变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！