General question - Has anyone seen or had experience with stored procedures that include BEGIN TRANSACTION and END TRANSACTION commands in a select statement? If so, what advantages/disadvantages are there to including them and conversely, what advantages/disadvantages are there to excluding them?
I am of the belief that they serve no purpose in a select statement and are totally unnecessary. Agree? Disagree?