LastMergedTime Property
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。
The LastMergedTime property returns the last time a merge replication operation occurred between the Publisher and the Subscriber.
語法
object.LastMergedTime
Parts
- object
An expression that evaluates to an object in the Applies To list.
Data Type
String
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetLastMergedTime(SQLDMO_LPBSTR pRetVal);
備註
Use the LastMergedTime property to determine whether replicated data at a pull Subscriber is up-to-date.
LastMergedTime returns the data formatted as YYYYMMDD hh:mm:ss.fff.
Date part |
Description |
---|---|
YYYY |
Represents the year in four digits. |
MM |
Represents the month in two digits (zero padded). |
DD |
Represents the day of the month in two digits (zero padded). |
hh |
Represents the hour using two digits, a twenty-four hour clock and zero padding. |
mm |
Represents the minute in two digits (zero padded). |
ss |
Represents the second in two digits (zero padded). |
fff |
Represents the fractional part of the second in three digits. |
For example, the value 20040512 18:12:00.000 is interpreted as 6:12 P.M., May 12, 2004.
[!附註]
If an application calls LastMergedTime on an instance of SQL Server version 7.0, an empty string is returned.