title: Execute insert statement when the case conditions are satisfied
body: <p>I have a stored procedure which has a insert statement.The procedure executes an insert statement when the user provides all the values as 0. If the user provides differnt values then a error statement should be returned.</p>
  
  <pre><code>case when @test1=0,@test2=0,@test3=0 then 
  {Insert statement} 
  Else
  Case when @test1=0,@test2=0,@test3=1
  {select “All cases should be 0”}
  Else
  Select “Please provide data”
  </code></pre>
  
  <p>In this case I thought case conditions works fine but after reading documentation and some other links it seems syntactically false to write such a statement.</p>
  
  <p>Anyother possible way to solve the problem.</p>