"Eddie Pazz" <drpazz@hotmail.com> wrote in message
news:uPDvGmtcEHA.996@TK2MSFTNGP12.phx.gbl...
> I have some business rules that I need to enforce before committing data.
> Normally I do this in my business objects. The analyst wants to implement
> the rules through sprocs. I have created a sproc for insert and one for
> update. My problem is that some rules apply when inserting and when
> updating, thus I would need to duplicate them in both sprocs. Should I
> create a third sproc that the other two would call to verify? Is this the
> correct way?
>
>

"Eddie Pazz" <drpazz@hotmail.com> wrote in message
news:uPDvGmtcEHA.996@TK2MSFTNGP12.phx.gbl...
> I have some business rules that I need to enforce before committing data.
> Normally I do this in my business objects. The analyst wants to implement
> the rules through sprocs. I have created a sproc for insert and one for
> update. My problem is that some rules apply when inserting and when
> updating, thus I would need to duplicate them in both sprocs. Should I
> create a third sproc that the other two would call to verify? Is this the
> correct way?
>
>

wrote:

>I have some business rules that I need to enforce before committing data.
>Normally I do this in my business objects. The analyst wants to implement
>the rules through sprocs. I have created a sproc for insert and one for
>update. My problem is that some rules apply when inserting and when
>updating, thus I would need to duplicate them in both sprocs. Should I
>create a third sproc that the other two would call to verify? Is this the
>correct way?

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%23jfM3ptcEHA.1000@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Create a INERT,UPDATE Trigger
>
> Create trigger tri_ins_upd for Insert, Update for <table>
> as
> .....
> .....Business rules
> .......
>