Re: Disallowing/Ignoring Insert based on certain column value

From: Immy (imtiaz_ullah_at_hotmail.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 08:50:26 +0100

Look up "Check Constraints" in BOL.

"SPhan" <susan@spryersoft.com> wrote in message
news:%23am%2393ChEHA.1276@TK2MSFTNGP09.phx.gbl...
> Can anyone help me on writing a trigger that disallows insert into the
table
> based on certain condition.
>
> for example if the value that is being inserted in Employee Name column
has
> text 'Unknow' then just ignore Insert.
>
>

Relevant Pages

  • Disallowing/Ignoring Insert based on certain column value
    ... Can anyone help me on writing a trigger that disallows insert into the table ... text 'Unknow' then just ignore Insert. ...
    (microsoft.public.sqlserver.programming)
  • Re: 1352 NUL bytes at the end of a page? (was Re: Assertion `s && s->tree failed: The sag
    ... No, no, I'm not claiming that _you_ are writing the NUL bytes. ... > elsewhere, we are writing to a tmp file, the tmp file is NOT mmapped. ... "write" calls can trigger it through the "commit_write" function. ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: GPRS PUSH
    ... Hows about sending an SMS message to the device to trigger it to act? ... > We're writing a compact framework application to do some field service ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Use a trigger for data integrity.
    ... That is the entire reason for the instead-of trigger. ... if I don't want the insert/update done what do I do? ... To quote BOL: ... And don't assume that the trigger logic executes for each row ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger is not working when I test
    ... I also can't help wonderining ... why on earth you are using a trigger for something that could be very simply ... CONSTRAINTS in BOL. ... >> the rows that may be changed by the user action. ...
    (microsoft.public.sqlserver.programming)