i am refferning to the below question posted,

What is the output of the following code (disregarding "X row(s) affected"):

CREATE TABLE TriggerTest (Value int)

GO

INSERT INTO TriggerTest VALUES (1)

GO

CREATE TRIGGER tr_TriggerTest ON TriggerTest AFTER UPDATEAS BEGIN SET NOCOUNT ON; IF UPDATE(Value) PRINT 'The trigger fired' ELSE PRINT 'The trigger did not fire'END

GO

--Set Value equal to itself

UPDATE TriggerTestSET Value = Value;

DROP TABLE TriggerTest;

=======================

I have tried this and got fallowing error,

Server: Msg 245, Level 16, State 1, Line 1

Syntax error converting the varchar value 'Value' to a column of data type int.

it is said that the trigger gets fired, then why 'The trigger fired' statement doesn't got printed.