Table
USE [demo]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cus](
[customername] [varchar](max) NULL,
[address] [varchar](max) NULL,
[Startdate] [date] NULL,
[enddate] [date] NULL,
[status] [varchar](8) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
//////////////////////////////////////////
SP
USE [demo]
GO
/****** Object: Trigger [dbo].[trigoninsert] Script Date: 10/19/2013 17:08:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[trigoninsert] on [dbo].[cus]
for
insert
as
declare @customername varchar(max);
declare @address varchar(max);
declare @Startdate date;
declare @enddate date;
declare @status varchar(6);
select @customername=customername from inserted;
select @address=address from inserted;
select @Startdate=Startdate from inserted;
select @enddate=enddate from inserted;
if(@enddate<getdate())>
begin
set @status='InActive';
rollback;
print 'the Value Cannot be inserted as the enddate is less than the current date';
end
begin
update cus
set status=@status where customername=@customername;
end
But Status Column Not Update for According to enddate