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.
[font="Times New Roman"]Anil Kubireddi[/font]