Post reply

Trigger Doubt

  • March 28, 2012 at 6:45 am

    #253201

    Is it not possible to create trigger for ntext,text and image data type columns?

    Regards

    Guru

  • March 28, 2012 at 6:55 am

    #1465627

    GuruGPrasad (3/28/2012)

    Is it not possible to create trigger for ntext,text and image data type columns?

    Regards

    Guru

    you cannot manipulate any column that is ntext,text or image from the INSERTED or DELETED tables inside a trigger.

    you can, however, join INSERTED or DELETED to the original table, and get the current value of those columns from the table itself.(that means you CANNOT compare it to the OLD value, but you CAN get it's current value.)

    see this very similar recent post

    http://qa.sqlservercentral.com/Forums/FindPost1269855.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 28, 2012 at 7:06 am

    #1465634

    Thank you Lowell

    Regards

    Guru

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply