Querry Delete Rows

[S37uP!Update]

Hello,
Well i need an querry script for mssql to delete the rows from two cloumns after 12 hour from when they added in the table !
I hope some one can help me !

 

[LostSpirit]

A google can help you on this issue practically give a script ready cause u never learn anything about SQL stuff's. That's basics to have or be an administrator of a server.

 

[S37uP!Update]

I am,i already search on google but i don't find any querry ... for what i need.

 

[emi]

I am,i already search on google but i don't find any querry ... for what i need.

You didn't understand his point.You have to learn to do it by yourself,not just done for you.

 

[-Jumong-]

First thing you need sir is find the query of deleting rows, are you trying to delete rows or data on that rows?...

After finding the query you can create a job for it to run according to your schedule or find another query or trigger.

 

[phiber]

@S37uP!Update:
delete from something where DATEDIFF(hour, date_col, getdate())>12

@jumong:
You cant delete "data" from a row, delete command dont work like that.
Its all or nothing.