Prepare a stored procedure using transactional processing

Assignment Help Computer Engineering

Reference no: EM132154481

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.

[VendorID] [int] IDENTITY(1,1) NOT NULL.

Reference no: EM132154481

Questions Cloud

Which processor runs faster and how many times faster : If two processors given below run exactly the same program in a perfect scenario, which processor runs faster and how many times faster?

How many people in your hometown would be interested : Suppose you have just 2 hours to determine how many people in your hometown would be interested in buying a pair of left-handed scissors.

Create a game of count 21 in which a player competes : Two people play the game of Count 21 by taking turns entering a 1, 2, or 3, which is added to a running total.

List the feasible alternatives : A college student determines that he will have only $250 per month available for his housing for the coming year. He is determined to continue in the university

Prepare a stored procedure using transactional processing : Prepare a stored procedure using transactional processing that inserts a new row into the Vendor table.

Mean and standard deviation for the level of support : The accompanying table gives the mean and standard deviation for the level of support variable.

Find the difference between output and input : The three economic criteria for choosing the best alternative are maximize the difference between output and input, minimize input, and maximize output.

Was there a significant difference : Several police officers were tested in an experiment to determine whether or not a suspects' behavior affected the officer's ability to accurately

State the correct economic criterion for each situation : The engineering school raffled off a car; tickets sold for $2 each or three for $5. When the students were selling tickets, they noted that many people.

User Account

All Pages