title: Best way to work with transactions in MS SQL Server Management Studio
body: <p>Let's say I have an SQL statement that's syntactically and semantically correct so it executes. </p>
  
  <p>In Management Studio (or any other query tool) how can I test SQL statements, and if I notice that they broke something, rollback (in a separate query?)</p>