I currently have the following trigger in place that will move a deleted row of data from one table to another identical table which fires when the user deletes a row: /****** Object: Trigger [dbo].[trgTransitListDeleteHistory] Script Date: 06/15/2009 10:55:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bcoffey
on
06-15-2009, 12:00 AM
Filed under: Trigger, UPDATE, SQLServer, TSQL, Update SQL Statement, update database with a numeric textbox value, triggers, Update database, update statement, update records, sqlscript, updating copies of database, update column, trigger table database, trigger table database error, update sql field set, Update SQL, Updating and WHERE clause ........and current user