TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Nepethya Rana
NA
335
151.6k
Syntax to create store proc to delete huge receords
Sep 23 2016 4:19 PM
I need to create a store procedure with a loop that takes two parameter numOfRowsToDelete and delayTime so that store proc delete the that numOfrows and wait for the delayTime and run again. How do I do it. I am new to database. Please help me
Reply
Answers (
4
)
Syntax to create store proc with transaction commit and roll
How to pass schema and table name in store proc