Updating multiple tables in sql
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
ORG_ID = @ORG_ID COMMIT BEGIN TRANSACTION is not the same as BEGIN which starts a block ( used in IF for example).
And I agree about the hack-i-ness of the suggested link (I might even suggest removing it).
Because of this indeterminacy, referencing other tables only within sub-selects is safer, though often harder to read and slower than using a join.Is it really worth doing all that to avoid writing two statements?