Write a stored procedure using transactional processing

Assignment Help Computer Engineering

Reference no: EM132154446

Two students may work together on this project and only one person needs to submit the work. Please make sure you include both names on this document. Students will be required to demonstrate to me during the week of Nov 28 that they have made progress on the actual code. This may be done in class or by appointment.

Stored Procedure Exercise

Write a stored procedure using transactional processing that inserts a new row into the Vendor table and then adds at least one new Invoice for that new Vendor. This program must include the ability to handle a failed transaction in which case it should issue an error message and a rollback.

Invoices: Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode,
Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Addres, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country,

InvoiceLineItem:

For the Vendor table the required columns are

[VendorName] [varchar](50) NOT NULL

[VendorCity] [varchar](50) NOT NULL

[VendorState] [char](2) NOT NULL

[VendorZipCode] [varchar](20) NOT NULL

Make sure you allow for a value for the Defaulted Columns, but these values should be optional as the database has predefined the default value is none is supplied.

[DefaultTermsID] [int] NOT NULL (acceptable values are 1, 2, 3, 4, or 5 with 3 being the default)

ALTER TABLE [dbo].[Vendors] ADD CONSTRAINT [DF_Vendors_TermsID] DEFAULT ((3)) FOR [DefaultTermsID] - this is the code that was used in the table definition that actually set the default value for the DefaultTermsID.

[DefaultAccountNo] [int] NOT NULL (there are 75 possible account values with 570 being the default)

ALTER TABLE [dbo].[Vendors] ADD CONSTRAINT [DF_Vendors_AccountNo] DEFAULT ((570)) FOR [DefaultAccountNo] - this is the code that was used in the table definition that actually set the default value for the DefaultAccountNo

Although VendorID (which is the Primary Key) is required for the table, you do not have to supply a value for this since it is an IDENTITY column which means the value is autogenerated.

Reference no: EM132154446

Questions Cloud

Find solutions to the smaller problems : One strategy for solving a complex problem is to break it into a group of less complex problems and then find solutions to the smaller problems.

Compute the synchronize control : compute the synchronize control for each amount of automatic dislocation of the rotor plus the equivalent synchronize torque.

Approach to test the hypothesis : Use the P-value approach to test the hypothesis. Assume that the population standard deviation s = 5oz.

What is the role of organizing in managing : Why is management important to an organization’s success? What is the role of organizing in managing?

Write a stored procedure using transactional processing : Write a stored procedure using transactional processing that inserts a new row into the Vendor table and then adds at least one new.

What criteria will you use in the given problem : When you make professional decisions involving investments in engineering projects, what criteria will you use? Contributed by D. P. Loucks, Cornell University.

Average content of juice per bottle equals : A machine is set up such that the average content of juice per bottle equals µ. A sample of 36 bottles yields an average content of 51.5oz.

The resources for the delivery of health services : Which has identified a health issue that affects the community and the resources for the delivery of health services.

State a research question that addresses : 1. State a research question that addresses the main outcome in the situation given.

User Account

All Pages