How to calculate records which were deleted from table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Please someone tell how to calculate the records that have been deleted from a table. Please help me to do this in a stored procedure. One more thing I want to know is if I have to use trigger for that? I don't know the correct way and solution, please help me to solve this problem.

Posted 14-Feb-13 3:21am

chander_rani

Updated 14-Feb-13 4:35am

Richard C Bishop

v2

Add a Solution

Comments

Sandeep Mewara 14-Feb-13 9:40am

how to calculate the records which have deleted from table
Are you maintaining any record of deletion? If not, you cannot.

ZurdoDev 14-Feb-13 9:53am

What do you mean calculate the records which are deleted? Do you mean get a count when you do the delete? Please explain more.

Chris Reynolds (UK) 14-Feb-13 10:00am

Sounds like you need a trigger. There are plenty of examples around on the web. If you tell us what you want to do when a record is deleted we can offer more specific help.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vyacheslav Voronenko · Answer 1 · 2013-02-14T04:51:00

As usually, there is no single correct solution, but one of the ways it could be achieved is a trigger. Trigger in a MSSQL has an access to inserted and deleted records referenced as @inserted and @deleted respectively.

Thus, as correctly mentions Chris Reynolds (BNY), one of the options could be the trigger which might call a specific stored procedure passing these records.

One of examples for such trigger could be found on a link below

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/e883cdbc-3b17-430e-823b-02ba800cffc9[^]

General info on @deleted @inserted in triggers on msdn

http://msdn.microsoft.com/en-us/library/ms191300.aspx[^]

Zafar Sultan · Answer 2 · 2013-02-14T04:51:00

Solution 3

declare a variable in your stored procedure like:

SQL

DECLARE @numberofrowsdeleted INT

use it like:

SQL

DELETE FROM YourTable WHERE conditionIsTrue
SET @numberofrowsdeleted = @@ROWCOUNT

@numberofrowsdeleted will give you the number of deleted rows.

Posted 14-Feb-13 4:51am

Zafar Sultan