instead of trigger to fulfill need to delete table before data is inserted

Question

instead of trigger to fulfill need to delete table before data is inserted

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 1

[font="Verdana"]I don't know whether it is logical, and even I didn't tried such thing yet, can you write delete statement inside the trigger for deleting the records from table on which you have written trigger?

Mahesh[/font]

MH-09-AM-8694

Garadin One Orange Chip Points: 29613 More actions · Answer 2

This is a duplicate post. No more responses here please. Respond to:

http://www.sqlservercentral.com/Forums/Topic786113-338-1.aspx

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]