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 |
|
mpolaiah
Starting Member
24 Posts |
 Posted - 2009-09-22 : 08:48:31
|
| Hi All,i am using sql server 2005i am mainiting the History of my tablesobefore update record how to insert the record in history tabletwo table have same columnsusing trigger please help meeeeeeeeeeeeeeeeeee..........yourspole. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-09-22 : 09:16:23
|
| Why you use Before Trigger?Use After trigger and insert the data to your history table from deleted(old value) table.Try like thisinsert into histoy_table (c1,c2,c3,c4)select c1,c2,c3,c4 from deletedSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
|
|
|
How To write before Trigger in sql server...