Database

CREATE TRIGGER Trig1
ON DB_TEST.tbl_table1
AFTER INSERT, UPDATE
AS

declare @date1 datetime
declare @stat numeric

select @date1=(SELECT datestarted from inserted)
PRINT 'date1 = ' + convert (varchar(50), @date1)
select @stat=(SELECT status_value from inserted)
PRINT 'stat = ' + convert (varchar(50), @stat)


if (@stat=2 and @date1<GETDATE()) BEGIN
   PRINT 'Executing update 1'
   UPDATE tbl_table1 set column1=(datediff(day,GETDATE(), @date1)) from tbl_table1 where status_value=2
   PRINT 'Rows affected = ' + convert (varchar(50), @@ROWCOUNT)
END
ELSE BEGIN
   PRINT 'Condition 1 not met'
END
if (@stat=2 and @date1>GETDATE()) BEGIN
   PRINT 'Executing update 2'
   UPDATE tbl_table1 set column1='date1 greater than current date' from tbl_table1 where status_value=2
   PRINT 'Rows affected = ' + convert (varchar(50), @@ROWCOUNT)
END
ELSE BEGIN
   PRINT 'Condition 2 not met'
END

Samarinder wrote:

very very urgent ....plz see with high priroty....

Samarinder wrote:

I have to developed Database comparator tool,

Samarinder wrote:

i found some source code in .net in this site

Samarinder wrote:

but not able to find in java.....

SELECT ROW_NUMBER() OVER (ORDER BY team_name ASC) AS ROWID, * from teams
where team_name like '%man utd%'