SqlTriggerContext.IsUpdatedColumn Method

Returns true if a column was affected by an INSERT or UPDATE statement.

Namespace: Microsoft.SqlServer.Server
Assembly: System.Data (in system.data.dll)

public bool IsUpdatedColumn (
	int columnOrdinal
public boolean IsUpdatedColumn (
	int columnOrdinal
public function IsUpdatedColumn (
	columnOrdinal : int
) : boolean
Not applicable.



The zero-based ordinal of the column.

Return Value

true if the column was affected by an INSERT or UPDATE operation.

Exception typeCondition


Called in the context of a trigger where the value of the TriggerAction property is not Insert or Update.

Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0