Re: Trigger question on constraints

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 08:25:23 -0500

Here is an article that Kalen wrote which may help
http://www.windowsitpro.com/SQLServer/Article/ArticleID/15524/15524.html 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <Alan@discussions.microsoft.com> wrote in message
news:343AC365-8CC6-4B5A-9EF7-25F9222B120C@microsoft.com...
> David,
>
>    Thank you for the reply, I think the 'Instead Of' is the way to go, but
I
> am trying to find how to use it, The books online mention it but do not
seem
> to say how to use it.
>   Do you have any expamles or shortcuts to documentation.
>
>   Thank you
>  Alan
>
> "David Portas" wrote:
>
> > You could rewrite it as an INSTEAD OF trigger that would just perform
the
> > updates you want to permit.
> >
> > You could also consider putting this logic in an SP rather than a
trigger.
> > You need triggers if your application updates tables directly but that
is
> > something you should be avoiding anyway. An SP could be a more
convenient way
> > to encapsulate different business rules for different functions in your
app.
> >
> > -- 
> > David Portas
> > SQL Server MVP
> > --
> >

Relevant Pages

  • Re: Trigger Question
    ... Pro SQL Server 2000 Database Design - ... I just decided that if my trigger for delete was ... >> SQL Server MVP ... >>> UPDATE OrderDetail ...
    (microsoft.public.sqlserver.programming)
  • Re: Question: Triggers
    ... Shelling out to the OS is not a quick thing to do inside a trigger. ... Tibor Karaszi, SQL Server MVP ... I have a VB.NET application which searches for the existence of these ...
    (microsoft.public.sqlserver.server)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiling error message 208: sorting the wheat from the chaff
    ... Profile load to a file then load the> file to a table or have Proviler load to a table directly. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)