Question

create a new stored procedure called Insert_ShippingMethod_Data and write the necessary code to insert the shipping method data into your tables

shippingMethods shipID company method 101 102 103 104 201 202 203 204 301 302 303 304 fRate vRate baseWeight Fedex Fedex Fedex Fedex UPS UPS UPS UPS USPS USPS USPS USPS 0.5 0.5 Standard Ground 10 Standard Air Express Air Next Day Air Standard Ground15 Standard Air Express Air Next Day Air Standard Ground 5 Standard Air Express Air Next Day Air 20 30 40 20 10 10 0.5 0.5 0.5 0.5 0.5 0.5 15 15 15 15 20 25 35 45 15 30 40 10 10

Answer 1

If you have any doubts, please give me comment...

CREATE PROCEDURE dbo.Insert_ShippingMethod_Data

@shipID NUMBER(4),

@company NVARCHAR(50),

@method NVARCHAR(50),

@fRate NUMBER(4),

@vRate NUMBER(3,2),

@baseWeight NUMBER(4)

AS

BEGIN

SET NOCOUNT ON

INSERT INTO dbo.shippingMethods(shipID, company, method, fRate, vRate, baseWeight)

VALUES (@shipID, @company, @method, @fRate, @vRate, @baseWeight)

END

GO

EXECUTE dbo.Insert_ShippingMethod_Data

@shipID = 101,

@company = 'Fedex',

@method = 'Standard Ground',

@fRate = 10,

@vRate = 0.5,

@baseWeight = 20

GO