How to upload more than one field?

[Evgeny Gopengauz]

If I need to upload a single value from some singular query to the local
variable it may be like this:

set @var = (select F from T where...)

Next, what to do if I need more than one?
Is it necessary to create a cursor, then open it, fetch and so on? Or may be
something like

set @var1, @var2 = (select F1, F2 from T where...)

Thank you.

[Dan Guzman]

You can assign values to multiple variables using SELECT:

SELECT
@var1 = F1,
@var2 = F2
FROM T
WHERE ...

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Evgeny Gopengauz" <ev***@ucs.ru> wrote in message
news:cd**********@news.rol.ru...

If I need to upload a single value from some singular query to the local
variable it may be like this:

set @var = (select F from T where...)

Next, what to do if I need more than one?
Is it necessary to create a cursor, then open it, fetch and so on? Or may be something like

set @var1, @var2 = (select F1, F2 from T where...)

Thank you.

[Evgeny Gopengauz]

> You can assign values to multiple variables using SELECT:

SELECT
@var1 = F1,
@var2 = F2
FROM T
WHERE ...

Great!! Thank you!!
I'm sorry for the stupid question, just novice....