title: How can I separate SQL queries
body: <p>Assume that I have the following queries</p>
  
  <pre><code>select userName, password, email 
  from tblUsersProfile 
  where email = '145' or userName = '112'
  
  select userName, password, email 
  from tblUsersProfile 
  where email = '80' or userName = '70'
  
  select userName, password, email 
  from tblUsersProfile 
  where email = '129' or userName = '169'
  
  select userName, password, email 
  from tblUsersProfile 
  where email = '1' or userName = '2'
  
  select 
      AVG(PokemonLevel) as AvgLevel, PokemonId 
  from 
      tblUsersPokemons 
  group by 
      PokemonId 
  order by 
      PokemonId asc
  
  insert into tblOnlineUsersCounts  
     select 
        (select 
            COUNT(LastMoveTime) 
         from 
            tblUsersProfile 
         where 
            LastMoveTime &gt; DATEADD(HOUR, -24, sysutcdatetime())),  
        (select 
            COUNT(LastMoveTime) 
         from 
            tblUsersProfile 
         where 
            LastMoveTime &gt; DATEADD(DAY, -7, sysutcdatetime())),
        (select 
            COUNT(LastMoveTime) 
         from 
            tblUsersProfile 
         where 
            LastMoveTime &gt; DATEADD(DAY, -30, sysutcdatetime()))
  
  select 
      count(Id) as TotalCount, PokemonId 
  from 
      tblUsersPokemons 
  group by 
      PokemonId 
  order by 
      PokemonId asc
  </code></pre>
  
  <p>Now when I execute them in SQL Server Management Studio, it tries all and if one fails all fails which means all of them is counted as a single query</p>
  
  <p>Also when I right click in SSMS and click <strong>analyze query in database engine tuning advisor</strong> it also count them as a single query instead of each one is independent queries</p>
  
  <p>So I want to format them in a way that both SSMS should treat them as each one of them is a separate query</p>
  
  <p>So even if one fails, SSMS should execute other working ones</p>
  
  <p>What is the proper format for achieving this ?</p>
  
  <p>Ty very much</p>
  
  <p>what are these downvotes for ?</p>