subject
Engineering, 08.11.2019 19:31 joshsd8479

Use northwind database and base your stored procedure off the columns found in the customer table. write a stored procedure named, custregion, that accepts a region as a parameter. the stored proc is to return only the customerid, companyname, and the region. write it so that it can return those rows where the region is a null value as well as allowing the user to submit via the parameter a region name such as bc, sp, or, df, isle of wight, etc. note: you must test for a null value using the is null statement and can't code a where clause using an '= null' as that is not correct and will result in no rows being returned.

ansver
Answers: 1

Another question on Engineering

question
Engineering, 04.07.2019 18:10
Aloaded platform of total mass 500 kg is supported by a dashpot and by a set of springs of effective stiffness 72 kn/m. it is observed that when the platform is depressed through a distance x = 12.5 cm below its equilibrium position and then released without any initial velocity; it reaches its equilibrium position in the shortest possible time without overshoot. find the position and velocity of the loaded platform 0.10 sec. after its release. if a further load of 400 kg is added to the platform, find, i) the frequency of damped vibrations, and i) the amplitude of vibration after 2 complete oscillations, given that the initial amplitude is 15 cm.
Answers: 1
question
Engineering, 04.07.2019 18:10
Acompressor receives the shaft work to decrease the pressure of the fluid. a)- true b)- false
Answers: 3
question
Engineering, 04.07.2019 18:10
The filament of an incandescent lamp has a temperature of 2000k. calculate the fraction of radiation emitted in the visible light band if the filament is approximated as blackbody
Answers: 2
question
Engineering, 04.07.2019 18:10
Atmospheric air has a temperature (dry bulb) of 80° f and a wet bulb temperature of 60° f when the barometric pressure is 14.696 psia. determine the specific humidity, grains/lb dry air. a. 11.4 c. 55.8 d. 22.5 b. 44.1
Answers: 1
You know the right answer?
Use northwind database and base your stored procedure off the columns found in the customer table. w...
Questions
question
Mathematics, 07.03.2020 00:07
Questions on the website: 13722362