title: Multiple condition in single IF statement
body: <p>I want to add multiple condition in single IF statement in SQL.</p>
  
  <p>I am not good in SQL &amp; referred some example, all are showing only one condition in IF.</p>
  
  <p>Here is my procedure.</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[AddApplicationUser]    
  (  
  @TenantId BIGINT,  
  @UserType TINYINT,
  @UserName  NVARCHAR(100),  
  @Password NVARCHAR(100)  
  )  
  
  AS    
  
  BEGIN   
  
  IF ((@TenantId IS NULL)  AND (@UserType=0 OR @UserType=1) )
    RAISERROR('The value for @TenantID should not be null', 15, 1) -- with log 
  </code></pre>
  
  <p><strong>Is this correct syntax in SQL for multiconditions in IF?</strong></p>