A(n) _____ identifies how you feel about an activity or subject. computer calculator interest inventory both b and c

Create a stored procedure sp_Q1 that takes two country names like 'Japan' or 'USA'as two inputs and returns two independent sets

Zigmanuir [339]

Answer:

Check the explanation

Explanation:

CREATE PROCEDURE sp_Q1

"at"country1 NVARCHAR(15),

"at"country2 NVARCHAR(15)

AS

BEGIN

SELECT SupplierID, CompanyName, Phone, Country FROM suppliers

where Country in ("at"country1,"at"country2)

SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Products

where SupplierID in(

SELECT SupplierID FROM suppliers

where Country in ("at"country1,"at"country2)) ORDER BY SupplierID

END

GO

-- Testing script.

DECLARE "at"RC int

DECLARE "at"country1 nvarchar(15)

DECLARE "at"country2 nvarchar(15)

-- Set parameter values here.

set "at"country1='UK'

set "at"country2='Canada'

EXECUTE "at"RC = [dbo].[sp_Q1]

"at"country1

,"at"country2

GO

Kindly check the attached images below to see how it looks like on a code editor.

7 0

3 years ago

Constructors have the same name as the ____.1. data members2. member methods3. class4. package

Svetradugi [14.3K]

Answer:

(3) option is the correct answer.

Explanation:

Constructors need to initialize the object in the memory. "To declare the Constructor for any class the user needs to specify the constructor name which is already the class name". This is an object-oriented language guideline.

It is because the object is created by the name of the class and Constructor is used to allocate the memory for the object. hence Constructor is created by the name of the class.

For example--

class test //class name test

{

test() //created a constructor with class name "test"

{

}

In the above example class name and constructor name are same if it not then it will gives a error.

Another option is not valid for the answer to the above problem because-

Option 1 is wrong because, for any class, the data member is a type of variable, which is used to store the data and is accessed with the help of an object.
Option 2 is wrong because, for any class, member function is a type of user function used to accessed the variable and expressions.
Option 4 is wrong because, package is a set used to hold classes and interfaces.

8 0

3 years ago

How do I change my keyboard's debounce time?

Zanzabum

in the control board type:

HKEY_CURRENT_USER\Control Panel\Accessibility\Keyboard Response\BounceTime

3 0

2 years ago

Read 2 more answers

Describe the basic features of the relational data model and discuss their importance to the end user and the designer. Describe

Mandarinka [93]

Answer:

The answer to this question can be described as follows:

Explanation:

Relational data model:

The use of data tables to organize sets of entities into relationships requires a relational data model. this model work on the assumption, which is a primary key or code, that is included in each table configuration. The symbol for "relational" data links and information is used by other tables.

Model Design:

This model is used for database management, it consists of structure and language consistency. It is design in 1969.

Importance of data model:

This provides a common standard for processing the potentially sound data in machines, that was usable on almost any one device.

Big Data:

It moves to locate new and innovative ways to handle large volumes of authentication tokens and to gather business insights when offering high efficiency and usability at an affordable cost at the same time.

6 0

3 years ago

Discribe two ways you can zoom in and out from an image

krek1111 [17]

Answer:

Select the Zoom tool, and then do any of the following:

Click and hold in the image to zoom in. Press Alt (Windows) or Option (Mac OS) to zoom out.

In the options bar, select Scrubby Zoom. Then drag to the left in the image to zoom out, or to the right to zoom in.

<h2>psst! pls, brailiest!</h2>

3 0

3 years ago

Read 2 more answers