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:
© 2014 Microsoft