Check this coding Status Colum not active automatically update for inserting time

See more:

SQL-Server

Table

USE [demo]
GO

/****** Object:  Table [dbo].[cus]    Script Date: 10/19/2013 18:55:12 ******/
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