Create Trigger while update Specific column of table

-
ALTER TRIGGER trgAfterContractDeedFileURLUpdate ON  [Contract]
FOR UPDATE
AS
begin
    declare @BusinessUnit nvarchar(50);
declare @newContractDeedUrl nvarchar(250);
declare @oldContractDeedUrl nvarchar(250);
    set @BusinessUnit = 'Insert To ContractDeedUrlHistory if Contract Deed URL is updated.'


select @newContractDeedUrl = ContractDeedUrl from inserted;

select @oldContractDeedUrl = ContractDeedUrl from deleted;

if(@newContractDeedUrl <> @oldContractDeedUrl)
begin
insert into
ContractDeedUrlHistory(ContractNo,ContractDate, OwnerID,ContractDeedUrl,Entry_By,Entry_Date)
SELECT
ContractNo,ContractDate, OwnerID,ContractDeedUrl,Entry_By,Entry_Date
FROM
deleted
end ;
     
end

Comments

Post a Comment

Popular posts from this blog

How to use DbFunctions.TruncateTime

-
var activeSchedulers = (from scheduler in DbContext.Scheduler                                                     where scheduler.isActive == "A"                                                     && DbFunctions.TruncateTime(scheduler.Date) == DbFunctions.TruncateTime(DateTime.Now)                                                     select scheduler).ToList();
Read more

Provision AWS EC2 Instance and RDS with Terraform, and Deploy Spring Boot App to EC2 Instance via GitHub Action Pipeline

-
Image
  These days, Terraform is a popular tool for managing infrastructure as code. Manually creating AWS EC2 instances and deploying Spring Boot applications to them can be challenging. In this tutorial, I will demonstrate how to use Terraform to provision an AWS EC2 instance and an AWS RDS MySQL database, and then deploy a Spring Boot project to that EC2 instance using a GitHub Action pipeline. Prerequisites: To follow this tutorial, you need to have the following prerequisites: An AWS account Terraform installed on your local machine. GitHub Account A Spring Boot Project Putty What We will do : Create AWS EC2 & RDS(MYSQL) Instance using Terraform Deploy Spring Boot Project in that EC2 Instance Using GitHub Action Create AWS EC2 & RDS(MYSQL) Instance using Terraform: Step 1: Create and Configure an AWS Free Tier Account AWS offers a free tier account with a 12-month free offer that allows you to use most of its resources for educational purposes. To get started on AWS, you fi...
Read more

Microsoft Access Connectivity from C#

-
<configuration>   <appSettings>     <add key="ConnectionString" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BCI.accdb;" />     <add key="ClientSettingsProvider.ServiceUri" value="" />   </appSettings> </configuration> http://aksadur.blogspot.com/2013/01/microsoft-access-connectivity-from-c.html
Read more