Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.