I had a case where I needed to insert multiple rows in a single query. A trigger is only executed once per insert, hence I only got it to trigger on a single record. The […]
MSSQL Only trigger on certain changes
Question I want it to only update the modified information if the QtyToRepair value has been updated… but it doesn’t do that. If I comment out the where then the modified information is updated in […]
Add Trigger
I have 2 tables: CREATE TABLE [dbo].[capalogin]( [ID] [INT] IDENTITY(1,1) NOT NULL, [Username] [VARCHAR](50) NULL, [PcName] [VARCHAR](50) NULL, [lastlogin] [DATETIME] NOT NULL, CONSTRAINT [PK_capalogin_history] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE […]
