title: How to Execute Multiple Insertion Error Happend RollBack Inserted Table in SQL Server stored procedure
body: <p>This is my code. How to avoid error happened any query automatically rollback already stored.</p>
  
  <pre><code>insert into muser(UserKey, Email, UserPassword) 
  values(@Key, @Useremail, 'test')
  
  set @UserId = SCOPE_IDENTITY()
  set @Key = NEWID()
  
  insert into  mUserProfile(UserProfileKey, UserId, UserEmail)
  values(@Key, @UserId, @Useremail)
  
  exec SP_Store @Useremail, @ClientId,
  </code></pre>