This hint specifies that a shared lock is taken on sql server in Updating joined tables table Production. Note that you must specify a valid server name for datasrc. BusinessEntityID ; GO The previous example assumes that only one sale is recorded for a specified salesperson on a specific date and that updates are current. The linked server name, MyLinkedServer, is then specified as part of the four-part object name in the form server. For more information, see ad hoc distributed queries Server Configuration Option. Product table for all rows that have an existing value of 'Red' in the Color column and have a value in the Name column that starts with 'Road'. The statement updates the value in the Color column of the Production. ProductAssemblyID, bom. DocumentSummary, inserted. Specifying a table variable as the target object The following example updates rows in a table variable. Document table.