BEGIN TRANSACTION represents a point at which the data referenced by a connection is logically and physically consistent. If errors are encountered, all data modifications made after the BEGIN TRANSACTION can be rolled back to return the data to this known state of consistency. Each transaction lasts until either it completes without errors and COMMIT [...]
Filed under: BEGIN TRANSACTION | Tagged: Author Raghunath Bhandari, BEGIN TRANSACTION, COMMIT TRANSACTION, Microsoft SQL server, MSSQL, MSSQL server, SQL help, SQL roll back, SQL Server, SQL Tips and Tricks | Leave a Comment »
