|
217 |
Error in Code
Beginning T-SQL, page 217, exercise 1 asks for all average weight of all touring bikes with a list price over $2,500.
The code provided ignores list price and averages the weight of the 22 touring bikes sold by Adventure Works Cycles. In fact, there are no touring bikes priced over $2,500.
|
12/30/2010 |
|
| 10 |
315 |
Error in Code
Currently reads:
CREATE PROCEDURE spUpd_MyContacts
@ContactID int
, @FirstName nvarchar(50)
, @LastName nvarchar(50)
, @Phone nvarchar(25)
AS
UPDATE MyContacts
SET FirstName = @FirstName
, LastName = @LastName
, Phone = @Phone
spUpd_MyContacts 5, 'Betrice', 'Rubble', '(222) 234-7654'
Should be:
CREATE PROCEDURE spUpd_MyContacts
@ContactID int
, @FirstName nvarchar(50)
, @LastName nvarchar(50)
, @Phone nvarchar(25)
AS
UPDATE MyContacts
SET FirstName = @FirstName
, LastName = @LastName
, Phone = @Phone
WHERE ContactID = @ContactID
|
11/15/2011 |
|
View Cart
