Hi, I need to Delete only one table´s part

Accepted answer

You can use

DELETE FROM [Table] WHERE

If you know what condition applies for those 18000 records, then you can write the correct WHERE clause.

+1

I try something like this:

delete from dbo.prueba where DATE = (select GETDATE()) -2

0

Ok, i need to write in the where clause that delete all less two days before the actual date.

For example my tables looks like:

1 2018 10 22

2 2018 10 23

3 2018 10 24

I need to delete only records before 2 days than today date (sysdate)

after delete with where clause It must looks like:

1 20018 10 24

0

DELETE TOP (18)

FROM TabaleName.

It deletes first 18 records from your table.

0