Write a stored procedure using transactional processing

Assignment Help Computer Engineering

Reference no: EM132153551

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 and InvoiceLineItems 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.

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: EM132153551

Questions Cloud

Distinction between a hypothesis and a prediction : What is a hypothesis? What is the distinction between a hypothesis and a prediction? What is a theory and how does this differ from a hypothesis?

Describe how you would configure the virtual disks : Given this environment, describe how you would configure the virtual disks for the VMs on both servers.

Give an o time algorithm : Give an O(n + r)- time algorithm that determines whether it is possible to designate some of the wrestlers as babyfaces.

Effectiveness of airbags at saving passengers : A study is being done on the effectiveness of airbags at saving passengers' lives in car accidents. 11,380 passengers in the study

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 .

Level of support for corporate sustainability of a randomly : Find the probability that the level of support for corporate sustainability of a randomly selected senior manager is less than 39 points.

Significant difference at the level : The officers were interviewed a week later and asked to describe their suspect. Their scores are below:

Can you think of a way to implement both stacks in one array : The total number of elements in the combined stacks is never more than 200 at any time, but we cannot predict how many are in each stack.

What are the three basic propagation mechanisms of los : There are two questions as follows. What are the three basic propagation mechanisms of Light of Sight (LOS) transmissions?

User Account

All Pages