One of a set of tools we're offering as a way to say thank you for being a part of the community.
CREATE TRIGGER [STLog1] ON [dbo].[TicketPoolHist] AFTER INSERT,UPDATE AS declare @Datestamp as datetime, @TableName as Char(20), @TableUID as Integer, @Status as Char(1) Select @TableUID = Identity_Column From Inserted INSERT INTO smi_Status(DateStamp,TABLENAME,TABLEUID,STATUS) VALUES (Current_TimeStamp,'TicketPoolHist',@TableUID,1)
|Access Crosstab Query with Multiple Values||4||47|
|Showing random records from database||10||44|
|What is the proper way to use for criteria in left join?||7||31|
|Stored Proc - Rewrite||42||59|