scriptcase sclookup get last inserted id

#SCRIPTCASE SCLOOKUP GET LAST INSERTED ID UPDATE#

The execution of LogCustomerCreditLimitChanges sql trigger can add log record in the log history table CustomerCreditLimitsHistory.

#SCRIPTCASE SCLOOKUP GET LAST INSERTED ID UPDATE#

This means that if an sql Update statement or if any sql Delete statement is executed on the target sql table CustomerCreditLimits, then and only then the SQL Server trigger named LogCustomerCreditLimitChanges will be executed automatically. SQL developers can create sql trigger executing the above sample TSQL script.Īfter sql developers create example SQL Server trigger, we can continue to this sql tutorial with inserting records to sample sql tables.ĬustomerId, CreditLimit, ValidFrom, ValidTo, InsertDate, InsertedByUserIdġ00, 20000, '20100101', '20120101', GETDATE(), 3Īfter we insert the first record into sql table using the above INSERT INTO statement, we can execute SELECT statement on both CustomerCreditLimits and CustomerCreditLimitsHistory history tables.Īlthough there is one record in CustomerCreditLimits sql table, in CustomerCreditLimitsHistory database table there is no record yet.Īctually we do not expect any record to be inserted into CustomerCreditLimitsHistory sql database table since we defined the sample sql trigger as sql Update and sql Delete trigger. INSERT INTO CustomerCreditLimitsHistory ( The second sql table CustomerCreditLimitsHistory is used to keep the history of changes and logs of the data kept in CustomerCreditLimits target sql table.ĬREATE TRIGGER dbo.LogCustomerCreditLimitChanges The first sql database table CustomerCreditLimits is used to save active sensitive data. So your tsql developers and SQL Server administrators decided to create sql trigger in order to log every change on records in CustomerCreditLimits sql tables.īelow I coped the CREATE TABLE sql scripts to use with tsql trigger example in this tutorial.

Your business requirements orders to keep the changes in this sensitive information.

The first database table CustomerCreditLimits will contain sensitive data. Let's create sql tables that sql developers will use in this sql trigger tutorial. The above Create Trigger syntax is also valid for MS SQL Server 2008, SQL Server 2005 and also valid for SQL Server 2000 database instances.

Scriptcase sclookup get last inserted id