When a view is created by using WITH VIEW_METADATA, all its columns, except atimestampcolumn, are updatable if the view has INSTEAD OF INSERT or INSTEAD OF UPDATE triggers. For more information about updatable views, see Remarks. Remarks ...
For more information about INSTEAD OF triggers, see DML Triggers. Partitioned Views If the view is a partitioned view, the view is updatable, subject to certain restrictions. When it is needed, the Database Engine distinguishes local partitioned views as the views in which all participating ...
When a view is created by using WITH VIEW_METADATA, all its columns, except atimestampcolumn, are updatable if the view has INSERT or UPDATE INSTEAD OF triggers. For more information, see the Remarks section inCREATE VIEW (Transact-SQL). ...
Trigger TriggerCollection TriggerEvents TypeConverters UnknownPropertyException UnsupportedCompatLevelException UnsupportedEngineEditionException UnsupportedEngineTypeException UnsupportedFeatureException UnsupportedObjectNameException UnsupportedVersionException UrnCollection UrnIdOption User UserCollection UserDefi...
This procedure changes the method that replication triggers use to connect from the Subscriber to the Publisher when changes are made at the Subscriber. You can also change settings associated with the Distribution Agent for an immediate updating subscription. For more information, see the procedures...
Triggers 获取直接在此元素上或在子元素中建立的触发器的集合。 (继承自 FrameworkElement) Uid 获取或设置此元素的唯一标识符(用于本地化)。 这是依赖项属性。 (继承自 UIElement) UseLayoutRounding 获取或设置一个值,该值指示是否应向此元素的大小和位置布局应用布局舍入。 (继承自 FrameworkElement) Ve...
Transform2All Tree-Nation (Independent Publisher) Trello Tribal Tribal - Maytas TRIGGERcmd TrueDialog SMS Trustual Tulip Tumblr (Independent Publisher) TuxMailer Twilio TxtSync tyntec 2FA tyntec Phone Verification tyntec SMS Business tyntec Viber Business tyntec WhatsApp Business Typeform U.S. Bank Trea...
If a view hasINSTEADOFtriggers, then any views created on it must haveINSTEADOFtriggers, even if the views are inherently updatable. See Also: "Creating a View: Example" alias Specify names for the expressions selected by the defining query of the view. The number of aliases must match th...
Triggers 获取直接在此元素上或在子元素中建立的触发器的集合。 (继承自 FrameworkElement) Uid 获取或设置此元素的唯一标识符(用于本地化)。 这是依赖项属性。 (继承自 UIElement) UseLayoutRounding 获取或设置一个值,该值指示是否应向此元素的大小和位置布局应用布局舍入。 (继承自 FrameworkElement)...
The PL/SQL varray that receives the output. Use this parameter to directEXPLAIN_REWRITE's output to a PL/SQL VARRAY I_AM_A_REFRESH Function This function returns the value of theI_AM_REFRESHpackage state. A return value ofTRUEindicates that all local replication triggers for materialized vie...