Exercise9 Create a function that displays the phone number of the recipients of a particular ordernumber from the recipient table. The function should display the phone number of therecipients on the basis of its corresponding order number from the recipient table whichuser inputs during the run time.

Sure, here's an example function in SQL that achieves this:

CREATE FUNCTION get_recipient_phone_number(@order_number INT)
RETURNS NVARCHAR(20)
AS
BEGIN
    DECLARE @phone_number NVARCHAR(20)
    SELECT @phone_number = PhoneNumber
    FROM recipient
    WHERE OrderNumber = @order_number
    RETURN @phone_number
END

When a user inputs an order number as a parameter to this function, it will return the corresponding phone number of the recipient from the recipient table. Note that this assumes that the `PhoneNumber` column in the `recipient` table is of type `NVARCHAR(20)`, but you can adjust the type and length of the variable to suit your needs.

相关问题

Create a procedure that displays the records of the IDs and the descriptions of the toyfrom the toys table. When a user calls that procedure, it should display the IDs anddescriptions of the first nine toys from the toys table

Sure, here's an example procedure in SQL that achieves this:

CREATE PROCEDURE display_first_n_toys
AS
BEGIN
    SELECT TOP 9 ID, Description
    FROM toys
END

When a user calls this procedure, it will display the ID and Description of the first nine toys from the toys table. Note that you can adjust the number of toys displayed by changing the parameter of the `TOP` keyword.

Create a procedure that displays the records of the IDs and the rates of the wrappers fromthe wrapper table when a user enters the description of the wrappers. On the basis of thedescription, the IDs and the rates of the corresponding wrappers should be displayed.

Sure, here's an example procedure in SQL that achieves this:

CREATE PROCEDURE display_wrapper_by_description
    @description NVARCHAR(50)
AS
BEGIN
    SELECT ID, Rate
    FROM wrapper
    WHERE Description = @description
END

When a user enters a description as a parameter to this procedure, it will display the ID and Rate of the corresponding wrapper(s) from the wrapper table. Note that this assumes that the `Description` column in the `wrapper` table is of type `NVARCHAR(50)`, but you can adjust the type and length of the parameter to suit your needs.