Monday, August 8, 2011

Use transaction in stored procedure

When timeout error occurs, the transaction is left open and wait for user handling. But using "SET XACT_ABORT ON" instructs the server to automatically roll back. It is recommended to always set this on. See:
Use Caution with Explicit Transactions in Stored Procedures.

Go implementation

See the eidogo project. It is written by Justin Kramer.

This is based on the eidogo project.

Another open source Go project is GNUGo.

Tuesday, August 2, 2011