
November 19th, 2007, 11:32 PM
|
|
Registered User
|
|
Join Date: Oct 2007
Posts: 1
Time spent in forums: 1 h 1 m 40 sec
Reputation Power: 0
|
|
Triggers
I cant able to use TEXT and IMAGE datatype using TRIGGERS.
sample code:
********************************
CREATE TRIGGER TRG_INSERT_LOG ON dbo.LogTable
AFTER INSERT
AS
BEGIN
INSERT INTO LogDescrition,LogImage
SELECT Description,Image from INSERTED;
END
********************************
while running this query system shows the error ;
It wont support the TEXT,IMAGE datatype in TRIGGERS.
pls. advise how to use data type like TEXT,IMAGE in TRIGGERS?
|