中级复习SQL1（Intermediate review SQL1）.docVIP

中级复习SQL1（Intermediate review SQL1） Database simulation operations exercise (intermediate) SQL Server 2000: The simulation method is used in the examination, and the background is connected to the actual database. The front desk is a query analyzer based on Web pages, so the database objects created will be stored in the database. If you create an object that already exists, you will make a mistake. You should first delete the object and recreate it. Each individual statement is required to be written in the same line, and different statements are written in the same branch. Do not use statements such as GO, IF, USE, EXIST, REPLACE, etc.. When you have finished writing the sentences, press the green arrow. The test system does not support selection execution (all statements on the screen are executed) when multiple steps are included in a topic, There are two ways to do it: write all the statements, then execute them at once; write a statement immediately, execute it successfully, delete the statement, and then write / execute / delete the following statement in turn. Notice the syntax template given in the topic. Note that the value of the character type should be in single quotes. In the query analyzer, use the SQL statement to do the following: 1, create table test, field ID, varchar (20), name varchar (30), age int. Create, table, test (ID, varchar (20), name, varchar (30), age, int) 2, create the index test of the field ID on table test_idx. Create, index, test_idx, on, test (ID) 3, insert two data into table test: insert, into, test, values (A01,abc, 20) Insert into, test, values (A02,ccc, 30) be careful not to use insert test values... 4, modify table test in ID for A01 record, and its name value tobcc. Update, test, set, name =bcc, where, id =A01 5, query all records in test, in accordance with the descending order of ID. Select * from, test, order, by, ID, desc 6, query test in ID for A01 record. Select *, from, test, where, id =A01 7. Delete the record of I