Delete data from sql table

Question

I want to delete data from table because of i donot require it.But i want to delete old data from table.Means i want to delete data date wise.

Answer 1

0

Presumably you have some criteria for determining whether the data is old enough to be deleted? If, for example, it has a CreateDate field that's suitable, then something like:

DELETE FROM myTable
WHERE CreateDate < DateAdd(y, -10, getdate())

This will remove all items from the table myTable which were created more than 10 years ago.

answered Oct 28 '11 at 12:02 PM

ThomasRushton ♦
29.1k ● 6 ● 9 ● 36

Hi,

Thanks for you reply

But my date format is TIME_STAMP(binint,null) and output is like as below.

1319415841689 1319529791610 1319370853868 1319370853930 1319370853946 1319370853977 1319370854024 1319370854040 1319370854071 1319370854133 1319370854149 1319370854180

Oct 29 '11 at 04:31 AM Tushar Thumar

then find the value of the timestamp column that is the last row that you want to remove and use that in the WHERE clause instead of the CREATEDATE that is in this answer.

Oct 29 '11 at 08:09 AM Fatherjack ♦♦

Nullable timestamp? That's worrying.

Oct 30 '11 at 01:28 AM ThomasRushton ♦

(comments are locked)

Delete data from sql table

Follow this question

Related Questions