Seems like triggers (another flavor of stored procedure) would be ideal for this. If unfamiliar with triggers, go search Microsoft and/or the web in general on "MS SQL server 2000 triggers"
-----Original Message----- From: Sam Jia [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 10:35 AM To: JRun-Talk Subject: find different data between 2 tables Hi there question is: I have 2 tables in MS SQL server 2000 with same structure. the data of 1st table may changed by insert, update, and delete query. for each fixed period, i want all these changes(new difference) of the 1st table during that period applied to the 2nd table. is there any build in command for this purpose? or there are other solutions. thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
