FilterClause Property
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。
The FilterClause property specifies a Transact-SQL WHERE clause used to filter row data published in the article.
構文
object
.FilterClause [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A string that specifies a Transact-SQL expression that is valid as the WHERE clause of a SELECT statement
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFilterClause(SQLDMO_LPBSTR pRetVal);
HRESULT SetFilterClause(SQLDMO_LPCSTR NewValue);
.gif "ms132963.note(ja-jp,SQL.90).gif") メモ : |
|---|
| SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString. |
解説
Filtering and horizontal partitioning are two methods that reduce the row data scope of an article. Either method, or both, can be used. The FilterClause property specifies that a row filter is applied to determine available data for an article.
| メモ : |
|---|
| If an application sets FilterClause after the initial snapshot has been created, a new snapshot must be generated and reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and distribution agent run. |
Applies To:
参照
その他の技術情報
SELECT 句 (Transact-SQL)
sp_articlefilter (Transact-SQL)