Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial


Update with Nolock at the From clause

Using table hints without keywird WITH is deprecated in future versions.

Microsoft SQL Server 2000

UPDATE <table_name> SET. FROM <table_name> AS <alias_name>(NOLOCK)

Microsoft SQL Server 2008

UPDATE <table_name> SET. FROM <table_name> AS <alias_name>

Example:

Microsoft SQL Server 2000:

UPDATE tab1 
SET tab1.col1 = 'aaa' 
FROM tab1 AS SWT_Al (NOLOCK) 
WHERE SWT_Al.col2 = 'bbb' 

Microsoft SQL Server 2008:

UPDATE tab1 
SET tab1.col1 = 'aaa' 
FROM tab1 AS SWT_Al 
WHERE SWT_Al.col2 = 'bbb'

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.