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 - 2002-02-14 : 11:03:41
|
| es4net writes "Hi,I have the following question on triggers:What will be the order of rows returned when a SELECT is done on the deleted and inserted tables ?For eg.SELECT * from deletedSELECT * from insertedDoes the "SELECT * from deleted" and the "SELECT * from inserted" return the rows in the same order?In this way it is possible to know that for an update, the first row in the deleted table(with old values for the row) corresponds to the first row in the inserted table(with the new values for the same row).It is possible to know the mapping between the deleted and inserted tables with primary keys. But what if there are no primary keys.Your reply is highly appreciated.Thanks in advance." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-14 : 11:29:39
|
| http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=12851 |
 |
|
|
|
|
|
Triggers: row order in deleted and inserted tables