Can you help me with the task in sql?
Possibly someone on the forum could help you with your task. But, unlike a live chat forum, it would be inefficient to have a two-way conversation (which would necessarily be non-real time) on this forum. So you should describe the problem that you want to solve, in detail, with code to generate sample data.
Can you help me?
I need to create a pot database that has:
-primary database file DB_ASSIG1 (size 1GB, increase 100MB) ;
-secondary database file DB_ASSEC1 (size 500MB, increase 50MB) ;
-file group FG_ASSIG1 and in it a secondary database file DB_ASSEC2 ;
-transaction log DB_log1.
After creating the database, create a table with the following structure in the database:
- Phone_ID, tip SMALLINT ;
- Phone_Name, tip VARCHAR(15) ;
- Phone_Type, tip VARCHAR (10) ;
- Description, tip VARCHAR(25) ;
- Price, tip SMALLMONEY ;
- Manufacturer_ID, tip integer.
After creating the database, subsequently add a new Design_ID column, of type integer, that will not have a NULL value. Create screen shot created bases and tables.
Thanks in advance.
Rose, please don't double-post. You stated in your other post that SQL wasn't working for you. Not sure what that means, but this sounds like homework. At least give it a try and post what you tried.