/* Query 2.

Read p.130-131 or watch the video on slide#1~2 of part(3) of Chapter 4.

Then, write a statement to execute the procedure sp_addlinkedserver to

create a linked server in your server with a name of your selection

so it represents the instructor's SQL Server running in his office

ENB301A. Write another statement to execute another procedure, which is

sp_addlinkedsrvlogin, to map your Windows login to an existing remote

login of the linked server. This login must be called 'student' with

a password also 'student'.

 

There is a Products2 table in the ClearWater database of the instructor's

SQL Server described above. Products2 has different contents from Products

of ClearWater.

 

Your job here is to write a SELECT statement to compare products in

Products2 (of ClearWater in the above remote server) with products in

Products of ClearWater in your own server and find out which have

the same ProductID but different CategoryID. Display their ProductID

(only in one column) and both CategoryID in 'CategoryID_myServer' and

'CategoryID_remoteServer', respectively.

*/

 

 

 

 

 

 

/* Query 3.

Use the same linked server you created in Query 2 and write a SELECT

statement to find catogeries of ClearWater in your server that are not

referenced or used by any product in the Products2 table of the linked

server. Display their CategoryID, CategoryName, and Description.

 

Hint: outer join

*/

 

 

 

 

 

 

/* Query 4.

Which products in Products table (of your server) have the same supplier

as that of product 63 and have a unit price lower than that of product 63?

Display their ProductID, SupplierID, and UnitPrice.

 

Do not hard code the supplier's SupplierID or name in your statement.

 

Hint: self join

*/

 

 

 

 

 

----------END----------

ComputerScienceExpert

(11)

Status NEW Posted 04 May 2017 01:05 AM My Price 9.00

-----------

Attachments

file 1493861797-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer