title: Trying to initialize 2 values in 2 variables using 1 query, is it possible to do this.?
body: <pre><code>SET @Password = (
      SELECT UserPassword,IsLocked 
      FROM [Authentication].[tblLogin] 
      WHERE UserName=@UserName)
  </code></pre>
  
  <p>i m trying to get both values userpassword and islocked in two variables to be used in same SP in next query. Is it possible or do i have to write two queries for this.
  Is it there a concept of arrays in sql server</p>