|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Need Homework Help SQL ASAP
Hello
I need some help with this assignment. I have to modify the PRODUCT_t table by adding an attribute QTY_ON_HAND and can be used to track finished goods inventory. The field should be an integer field of 5 characters and should accept only positive numbers. So far I have something like this: INSERT into PRODUCT_t (QTY_ON_HAND, ) ("3", integer(5)); Could someone please show me how to write the entry. Thanks |
|
#2
|
|||
|
|||
|
Think you need ALTER TABLE command. Check this link:
http://msdn.microsoft.com/en-us/lib...261(VS.71).aspx |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Need Homework Help SQL ASAP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|