Posted by Erland Sommarskog on 08/17/07 07:11

Yas (yasar1@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.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: ODBC Timeout problems but very hard to pin down
• Prev in forum: Re: How to create an admin with some limitations?
• Thread view: Re: MS SQL copy new and modified rows from TABLE1 to TABLE2

[Reply to this message]