Oharra
Baimena behar duzu orria atzitzeko. Direktorioetan saioa has dezakezu edo haiek alda ditzakezu.
Baimena behar duzu orria atzitzeko. Direktorioak alda ditzakezu.
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The SubsetFilterClause property specifies a Transact-SQL WHERE clause used to partition data horizontally in the merge replication article.
Sintaxis
object
.SubsetFilterClause [=value]
Parts
- object
An dxpression that evaluates to an object in the Applies To list
- value
A string of 1,002 characters or fewer that specifies a Transact-SQL WHERE clause
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSubsetFilterClause(SQLDMO_LPBSTR pRetVal);
HRESULT SetSubsetFilterClause(SQLDMO_LPCSTR NewValue);
[!NOTA] 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.
Notas
If an application sets SubsetFilterClause after the initial snapshot has been created, a new snapshot must be generated and then reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and merge agent run.