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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Retrieve Data from Table When U Delete Data

Author  Topic 

vedjha
Posting Yak Master

228 Posts

Posted - 2008-07-01 : 07:41:57
Hai friend's
There is any Option to retrive Data when u Dalete Data From Table

Ved Prakash Jha

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-01 : 07:43:52
Yes. A DELETE trigger.
Or also OUTPUT statement if using SQL Server 2005 or later.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2008-07-01 : 07:45:08
How

Ved Prakash Jha
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-01 : 07:57:36
Open Books Online.
Search for CREATE TRIGGER.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -