I have created an After Update trigger. I can get modified row from the Inserted table, but is there any way to get the "original" row I mean I'd like to compare two rows to get what exactly was changed.
Some kind of row versions in triggers?
Hot Topic
- Detect installed version?
- Problem activating a server on home PC
- Error: SQL Server does not exist or access denied. (Error code 17).
- Error detaching sql express database using SMO
- import text file into mssql
- Connectivity Issues in AMO
- cant connect to server from another machine
- Stuck between "Failed to generate user instance" and "An attempt to attach...failed"
- Getting Output Columns OLEDB Command
- Rollback in a trigger??? (explicit/autocommit transactions)
SQL Server
- Sql Sever 2000 Reporting Services
- populating numbers instead of description in performance objects
- importing and exporting tables
- Analysis Services 2005 OLE DB Provider Error
- Object Oriented Data Storage
- Cannot generate SSI Context
- dts in 2005
- Overlapping Header for Table
- Package Configuration in SQL
- Need Help creating a SSIS Package (Newbie)
Some kind of row versions in triggers?
Pachacutec
Martin Platt