title: In Python, Using pyodbc, How Do You Perform Transactions?
body: <p>I have a username which I must change in numerous (up to ~25) tables.  (Yeah, I know.)  An atomic transaction seems to be the way to go for this sort of thing.  However, I do not know how to do this with pyodbc.  I've seen various tutorials on atomic transactions before, but have never used them.</p>
  
  <p>The setup: Windows platform, Python 2.6, pyodbc, Microsoft SQL 2005.  I've used pyodbc for single SQL statements, but no compound statements or transactions.</p>
  
  <p>Best practices for SQL seem to suggest that creating a stored procedure is excellent for this.  My fears about doing a stored procedure are as follows, in order of increasing importance:
      1) I have never written a stored procedure.
      2) I heard that pyodbc does not return results from stored procedures as of yet.
      3) This is most definitely Not My Database.  It's vendor-supplied, vendor-updated, and so forth.</p>
  
  <p>So, what's the best way to go about this?  </p>