Older than # days


	SqlCommand1->CommandText = "DELETE FROM tblMyTable WHERE DATEDIFF(day, getdate(), MyColumnName) < -10";		//Delete all records older than # days ago
	SqlCommand1->ExecuteNonQuery();

 

Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published.