Posted by Nacho on 08/07/06 17:25

Thanks to both of you!!!
It's good point to handle it in the query (I suposse when you read
values after) but then, how it would be? How can I clip values in the
select statement ?



Erland Sommarskog wrote:
> Roy Harvey (roy_harvey@snet.net) writes:
> > I would only add that a WHERE clause on the UPDATE in the trigger
> > would save updates when the value is already within the range:
> >
> > WHERE t.col < 0 OR T.col > 10000
>
>
> Good point! Thanks, Roy!
>
>
> --
> 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: understanding triggers
• Prev in forum: understanding triggers
• Thread view: Re: Understanding constraints and binding

[Reply to this message]