Updating t-SQL using table Aliases Posted on 2012-12-24 by mike UPDATE Q SET Q.FIELDTOBESET = 'NEW VALUE' FROM YOUR_TABLE Q WHERE Q.ID = 1010011010;