Re: Trigger and SP

Previous message: Anith Sen: "Re: Primary key on temp table not unique?"
In reply to: mike: "Trigger and SP"
Messages sorted by: [ date ] [ thread ]

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 12/14/04

Next message: Brandon Lilly: "Re: Trigger and SP"

Date: Tue, 14 Dec 2004 15:46:51 -0600

Use the inserted & deleted tables which are accessible within the trigger.
For details, refer to SQL Server Books Online.

-- 
Anith

Next message: Brandon Lilly: "Re: Trigger and SP"

Relevant Pages

Re: keeping duplicates with certain associated fields
... Refer to SQL Server Books Online for syntax of a SELECT statement ...
(microsoft.public.sqlserver.programming)
Re: foreign key constraint without database diagram
... Refer to SQL Server Books Online for more details for syntax & examples. ...
(microsoft.public.sqlserver.programming)
Re: Column alias in Select with Case
... Also, refer to ... SQL Server Books Online for the correct syntax for CASE. ...
(microsoft.public.sqlserver.programming)
Re: Using variable for INT in SELECT TOP...
... Because it is not the correct T-SQL syntax. ... topic SELECT in SQL Server Books Online, ... refer to similar posts and responses in the google ...
(microsoft.public.sqlserver.programming)
Re: Best way to kick out users from DB
... There is an ALTER DATABASE option with which you can set it to SINGLE_USER ... Refer to SQL Server Books Online for details. ...
(microsoft.public.sqlserver.programming)