CODEWITHSUNDEEP
sqlsql-servert-sqlsql-server-2008-r2
kaka mishoo
kaka mishoo

Reputation: 251

how to set two Variable with one select in sql

i have two Variable type in t-sql and want set they in sql. i use this code:

DECLARE @Id int
DECLARE @Name nvarchar(100)
set @Id, @Name = (Select Id, Name From Member Where username = @username)

but this not working, and i not want use this code:

set @Id = (Select Id From Member Where username = @username)
set @Name = (Select Name From Member Where username = @username)

i have use one select.

Upvotes: 0

Views: 97

Answers (1)

tweray
tweray

Reputation: 1003

Here's the right syntax for what you want to do:

DECLARE @Id int
DECLARE @Name nvarchar(100)

SELECT @Id = Id, @Name = Name
From Member 
Where username = @username

Upvotes: 6

Related Questions