Posted by Hugo Kornelis on 08/18/07 06:25

On Fri, 17 Aug 2007 19:47:32 -0700, Yas wrote:

>On 17 Aug, 08:11, Erland Sommarskog <esq...@sommarskog.se> wrote:
>> Yas(yas...@gmail.com) writes:
>> > DOH!!! what a silly mistake. :-)
>>
>> It's often that when you work with something you are not really confident
>> that you look for the difficult mistakes and overlook the simple typos.
>>
>> > do you think apart from that its fine
>> > for inserting new rows into Table2 from Table1 trigger?
>>
>> Looks good to me. I would have used NOT EXISTS rather than the LEFT JOIN,
>> as I think that expresses more clearly what is going on. But that's a matter
>> of taste.
>>
>
>Thanks for all your advise and help! by the way do you if there is a
>way to edit/change a Trigger once it has been created in MS SQL?

Hi Yas,

Yes. Simply use ALTER TRIGGER instead of CREATE TRIGGER.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: SELECT a random 10 records from table....easy newbie question
• Prev in forum: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2
• Thread view: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2

[Reply to this message]