Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-17 : 11:08:14
|
Nilesh writes "Hi,
I am writing a trigger for update of a particular column.
My problem is the table on which i had writtern the trigger have multiple records.I want to get details of the row of the particular column that is updated.
i tryed using this qry.
select * from table_name UPDATED.
but this is not returning me the affected row values.
In short is there any way to get the values of the affected row
(like in ORACLE we have oldval)" |
|
|
|
|
|
Sql Server 7.0