Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mark01
Starting Member
1 Post |
 Posted - 2009-04-04 : 18:58:51
|
| Hi I'm new to sql and what I would like to do is to create database that has columns with days and other stuff,every new day database should automatically delete records of old day.Can someone plese post me some links with tutorials about this subject.THANKS |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-04-05 : 03:42:12
|
| If u store date in your database also then just Schedule a job in which you can write your delete statements like this,,if you have the column which stores date in which data entered to yourtable...delete from urtable where yourdatecolumn=dateadd(dd,-1,getdate())so just havr to schedule your job which runs on daily basis,,,may be this gonna solve your problem Thanks.. |
 |
|
|
|
|
|
Cleaning Sql database