In Focus
MOBILE: HTML 5 vs. Native Apps
Istanbul Chapter May 2013 2nd Seminar Announced : Learn WinJS, Windows Store, MVC
ANNOUNCEMENT: April 2013 Month Winners
Email :
Password :
Remember me?
Forgot password
Technologies
Monthly Leaders
ASK A QUESTION
C# Programming
Multi-threading
Microsoft Surface
Community Services
Java
.NET General
Office Interoperability
ReFS
Current Affairs
JQuery
Active Directory
Printing
Silverlight 5
Fun and Jokes
JSP
ADO.NET & Database
Project Management
WCF
Job Opportunities
Multimedia, Graphics, Flash
AJAX & Atlas
Remoting
Windows 8
Leadership
PHP
Algorithms & AI
Reporting
Windows Azure
Mac for Windows
Social Networking
Arrays & Collections
Robotics and Hardware
Windows Store Apps
Microsoft Feedback
TypeScript
ASP.NET & Web Development
Security & Cryptography
Workflow Foundation
Open Source Projects
Web Hosting
C# Language
Setup & Deployment
WPF
Operating Systems
Website Management
C# References
Sharepoint
XAML Language
Paid Projects
Windows Azure
CLR & .NET Internals
Speech & Voice Recognition
Site and Forums Feedback
Prizes, Awards, MVP
Windows Phone 7
COM Interoperability
Tablet PC
Announcements
Students & Beginner Projects
Database
Custom Controls
Testing and QA
Author Guidelines
Test Category
Database General
Design and Architecture
Visual Basic .NET
Bugs and Problems
Training & Certification
Oracle
Embedded Development
Visual C++
Forums Feedback
Web Development
SQL
Enterprise Development
Visual Studio 11
Site Feedback & Suggestions
Advertising, Marketing, SEO
SQL Server
Games, DirectX, and XNA
Visual Studio 2010
Site Spams
Android
Products
GDI+ and DirectX
Web Services
Miscellaneous
Cloud Computing
Office 2013
General
Windows Forms
.NET Books
Expression Tools
Products
LINQ
Windows Services
Ask the Author
HTML 5
SharePoint 2013
Migrating to .NET
Cutting-Edge
Career Advice
HTML, JavaScript, CSS
Windows 8
Mobile Development
.NET 5.0
Coffee, Chai Lounge
iPhone, iPad
Forum guidelines
Home
»
SQL Server
»
Delte_Data& Shedule SP
Author
Question
shakib qureshi
Delte_Data& Shedule SP
Posted on: 13 Dec 2012
Hi,
Create a store procedure to delete the data from table, the rule is, look for date, if it is before 12 months delete that row.We need to schedule this Sp weekly or monthly
Please let me know what query should i write for this....
Reply
Quick Reply
Report a Spam
Our Recommended Solutions
User Defined Error Message in SQL Server 2012
Google Analytics API integration with ASP.Net
Display Records Horizontally in a Repeater Control
Add a Data Connection to SharePoint List or Library in InfoPath Form Template
Understanding Database Stored Procedures
Display Stored Procedure Output Parameter Value With Query Window in SQL Server 2012
Stored Procedure With a Return Value in SQL Server 2012
Creating a Simple ASP.NET CRUD Application Using SQL CE 4 and Entity Framework Code First.
How to Show Records In a GridView Using DropDownList in Web Application
Consuming WebAPI Using jQuery
[ + ]
Author
Reply
Deepak Kumar Verma
0
0
Re: Delte_Data& Shedule SP
Posted on: 16 Dec 2012
Hi Shakib,
You have to create a Job to do it. To know about how to create a Job, follow this link:
http://msdn.microsoft.com/en-in/library/ms187910.aspx
Reply
Quick Reply
Quick Reply:
SEARCH ANSWERS
All
C# Programming
Cutting-Edge
Site and Forums Feedback
Miscellaneous
Web Development
Database
Products
Any Word
Exact Word
Our recommended forum posts
Get the list of sp name from the package from oracle by C#
Convert Select into update
open this?
Getting Error when using Calling option with WP7 toolkit
How to use FileUpload inside GridView inside UpdatePannel??
from my SP i want pending amt should be come tolast rows
C# and Trackbar
from my SPoutput, thestudid,namecolumncannot be repeat
How to upload the files and folder in SP 2010 doc library
How to Update Multiple table records using table alias???
HOT QUESTIONS
Import/Export Generic List Objects
C# read xml data information
how to sort the date in dd mm yyyy
C# Binaryreader Position
javascript for submit form without using submit button
Create List accessible for other classes
Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)
mathematical euation
About Textbox
Congratulation Vinod Kumar
SPONSORED BY
DynamicPDF ReportWriter Suite
PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.