Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

SET SQLBUFFERING Command

Visual Studio 2005

Specifies if data in a SQL - SELECT statement is based on buffered data or data written to disk.


SET SQLBUFFERING ON | OFF

Parameters

ON

Specifies that the SQL - SELECT statement uses local buffered data if available. If data is not buffered, then data from disk is used.

OFF

(Default) Specifies that the SQL - SELECT statement uses data from disk.

This SET command is scoped to the current data session. If you want more control at the table level, use the WITH (BUFFERING = ON | OFF) clause in the SQL - SELECT statement. It overrides the SET SQLBUFFERING statement.

You can use SET(“SQLBUFFERING”) to query the current setting.

Community Additions

ADD
Show:
© 2015 Microsoft