title: Multiple Select vs Single Select Statement
body: <p>I was just wondering whats the difference between doing multiple selects vs. using a single select is there any performance gain? I saw someone did it, and I feel its like kinda out of hand such as below;</p>
  
  <pre><code>select @a = cBranchName from mstores where nBranchCode = 1
  select @b = cBranchAddress from mstores where nBranchCode = 1
  select @c = dCreateDate from mstores where nBranchCode = 1
  select @d = AssignedCompanyId from mstores where nBranchCode = 1
  select @e = StoreFormat from mstores where nBranchCode = 1
  </code></pre>
  
  <p>vs. </p>
  
  <pre><code>select @a = cBranchName 
    ,@b = cBranchAddress
    ,@c = dCreateDate
    ,@d = AssignedCompanyId
    ,@e = StoreFormat from mstores where nBranchCode = 1
  </code></pre>
  
  <p>I also presume that the 5 select's make 5 trips to the database, how can I prove that single select statement is faster than the 5 select statements,</p>
  
  <p>Even though just by looking at it, I already thought that the single select statement is significantly faster than the multiple selects.</p>