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
Santosh Reddy
NA
64
20.8k
stored procedure deletion statement
Mar 3 2017 12:07 AM
Write a script that creates and calls a stored procedure named test. This procedure should include a set of two SQL statements coded as a transaction t o delete the row with an invoice ID of 114 from the invoices table. To do this, you must first delete all line items for that invoice from the invoice_line_items table. If these statements execute successfully, commit the changes, otherwise roll back the changes.
Reply
Answers (
3
)
How to calculate datetime udf function problems
Stored Procedure to divide two columns and store the result