How can I select multiple values into locally declared variables in a SQL Server Stored Proc?

Question

Here's what I have:

DECLARE Name  VARCHAR(20)
DECLARE Pass  INT
SELECT  Name,
        Pass,
FROM    AdminTest
WHERE   TestId = @TestId

But this selects and reports.

How can I have the values stored into the local variables?

Giorgi Nakeuri · Accepted Answer · 2015-02-12 06:08:26Z

4

It is incorrect declaration of variables. You should declare variables using @. Do something like this:

DECLARE @Name  VARCHAR(20)
DECLARE @Pass  INT
SELECT  @Name = Name,
        @Pass = Pass,
FROM    AdminTest
WHERE   TestId = @TestId

answered Feb 12, 2015 at 5:59

Giorgi Nakeuri

35.9k8 gold badges50 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1