delet data in tables

• hodhod26

  Mr or Mrs. 500

  Points: 515

  More actions

  September 23, 2009 at 10:21 am

  #211398

  dear all,

  i need to delet data from certain table (not the table it self) automatically every day.

  thanks and best reagrd.

• Sergey Vavinskiy

  SSCarpal Tunnel

  Points: 4469

  More actions

  September 23, 2009 at 10:59 am

  #1057655

  So, create a scheduled job and use a statement TRUNCATE TABLE Your_Table_Name as a Step of this job.

  Don't forget to replace a table name with a real one in my code.:-)

• hodhod26

  Mr or Mrs. 500

  Points: 515

  More actions

  September 23, 2009 at 11:09 am

  #1057661

  can you explain how can i do it because i am begginer in sql

  thanks.

• Sergey Vavinskiy

  SSCarpal Tunnel

  Points: 4469

  More actions

  September 23, 2009 at 11:15 am

  #1057668

  Go to the origin::-)

  http://msdn.microsoft.com/en-us/library/ms187910.aspx