April 17th, 2004, 01:39 PM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Need Help!
Can someone help me with this case here I am really new to SQL.
-------------------------------
ARTIST.Name
ARTIST.Nationality
TRANSACTION.PurchaseDate
TRANSACTION.SalesPrice…
CUSTOMER.Name
CUSTOMER.Phone.AreaCode
CUSTOMER,Phone.LocalNumber
CUSTOMER.Name…
The ellipses (…) refer to structures that can repeat.
Code SQL statements to update this view as follows:
- Change the spelling of Mark Tobey to Mark Toby.
- Create a new transaction, work, and customer data in a structure named NewTrans.
- Add new interested customers for Mark Toby. Assume they are stored in a collection that you can access with the command “For Each NewCust.Name.”
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
