If You want to know what are the rows updated then u can use do it in two ways..
1. Write a select Statement before Update Statement selecting rows which will be updated Like...
Select Columnname from TableName Where Condition
Update TableName set column= something Where Condition
2. U can use a
TRIGGER for update of that Particular Table and save those records in to some new table...
Check this link for Triggers[
^]
CREATE TRIGGER TriggerName
ON TableName
AFTER UPDATE
AS
IF ( UPDATE (ColumnName))
BEGIN
END;
If you just want to Know the no of Rows affected by a statement u can use
@@RowCount
...
Create Table #Test(id Int, value Nvarchar(40))
Insert into #Test
Select 1,'Value1' Union All
Select 2,'Value2' Union All
Select 3,'Value3' Union All
Select 4,'Value4'
Select @@ROWCOUNT [RowCount After Insert]
Select * From #Test
Select @@RowCount [RowCount After Select]
Update #Test Set id=1 where id<4
Select @@RowCount [RowCount After Update]
Update #Test Set id=1 where id=0
Select @@ROWCOUNT
Drop Table #Test
you can fetch column update's date if column is primary key/foreign key like this
Select * From sys.objects where type_desc in('PRIMARY_KEY_CONSTRAINT','FOREIGN_KEY_CONSTRAINT')
Order by modify_date Desc
Hope this Helps...