Export (0) Print
Expand All

Table Hint (SQL Server Compact)

Specifies that the query optimizer use a table scan, one or more indexes, or a locking method with the associated table and for the associated SELECT, INSERT, UPDATE, or DELETE statement. Although this is an option, the query optimizer can typically pick the best optimization method without hints being specified.

For a list of locking hints that you can use in SQL Server Compact, see Locking Hints.

The following example selects all rows from the Products table and uses the NOLOCK table hint.

SELECT * FROM Products WITH (NOLOCK)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft