Home Forums SQL Server 2008 SQL Server 2008 - General Process deadlock RE: Process deadlock
sarath.tata
SSCommitted
Points: 1640
More actions
March 6, 2015 at 9:02 pm
#1782334
Thanks for your ideas. I'll look into them. By the way, do you mean this below on the usage of alias in UPDATE?
UPDATE asft SET LastRemoved = NULL
instead of
UPDATE asset.tblAssetSoftware SET LastRemoved = NULL