title: What is the syntax meaning of RAISERROR()
body: <p>I just created a Instead After Trigger whose syntax is given below:</p>
  
  <pre><code>Create trigger tgrInsteadTrigger on copytableto
  Instead of Insert as 
      Declare @store_name varchar(30);
      declare @sales int;
      declare @date datetime;
  
      select @store_name = i.store_name from inserted i
      select @sales = i.sales from inserted i
      select @date = i.Date from inserted i
  begin
      if (@sales &gt; 1000)
          begin
          RAISERROR('Cannot Insert where salary &gt; 1000',16,1); ROLLBACK;
          end
      else
          begin
          insert into copytablefrom(store_name, sales, date) values (@store_name, @sales, @date);
          Print 'Instead After Trigger Executed';
          end
  End
  </code></pre>
  
  <p>In the above syntax I have used <code>RAISERROR('Cannot Insert where salary &gt; 1000',16,1)</code></p>
  
  <p>But when I write <code>RAISERROR('Cannot Insert where salary &gt; 1000')</code> it gives the error "Incorrect syntax near ')'" on the same line.</p>
  
  <p>Can anyone please explain the use of (16,1) here.</p>