How can we help you today? How can we help you today?

Refactoring a Trigger

I was writing a trigger and part of my code is

select id from inseterd

then I click option of Qualify Objects Names

it became
select id from dbo.inseterd which is incorrect and giving me syntax error when I try to save the trigger
dineshasanka
0

Comments

1 comment

Sort by
  • Andras B
    dineshasanka wrote:
    I was writing a trigger and part of my code is

    select id from inseterd

    then I click option of Qualify Objects Names

    it became
    select id from dbo.inseterd which is incorrect and giving me syntax error when I try to save the trigger

    Thank you, this is a bug we are aware of, and the final version will preserve both the [inserted] and the [deleted] tables.

    Many thanks for reporting this problem,

    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.