Setting two scalar variables in one SELECT statement?

April 3, 2023 by Tarik

DECLARE @a int;
DECLARE @b int;

SELECT @a = StartNum, @b = EndNum 
FROM Users 
WHERE UserId = '1223'