轻松掌握SQL(第五版上).pdfVIP

APPENDIX E Glossary of Common SQL Commands * The asterisk character returns all the columns of a particular table. ALTER DATABASE ALTER DATABASE database_name; The ALTER DATABASE statement changes the size or settings of a database. Its syntax varies widely among different database systems. ALTER USER ALTER USER user The ALTER USER statement changes a user’s system settings such as a password. BEGIN TRANSACTION 1 BEGIN TRANSACTION transaction_name 2 transaction type 3 if exists 4 begin The BEGIN TRANSACTION statement signifies the beginning of a user transac- tion. A transaction ends when it is either committed (see COMMIT TRANSAC- TION) or canceled (see ROLLBACK TRANSACTION). A transaction is a logical unit of work. CLOSE CURSOR close cursor_name The CLOSE cursor_name statement closes the cursor and clears it of data. To completely remove the cursor, use the DEALLOCATE CURSOR statement. PDF:2 APPENDIX E: Glossary of Common SQL Commands COMMIT TRANSACTION COMMIT; The COMMIT TRANSACTION statement saves all work since the beginning of the transaction (since the BEGIN TRANSACTION statement was executed). CREATE DATABASE CREATE DATABASE database_name; The CREATE DATABASE statement creates a new database. Many different options can be supplied, such as the device on which to create the database and the size of the initial database. CREATE INDEX CREATE INDEX index_name ON table_name(column_name1, [column_name2], ...); An index can order the contents of a table based on the contents of the indexed field(s). CREATE PROCEDURE CREATCCREATE PROCEDURE procedure_name [[(]@parameter_name datatype [(length) | (precision [, scale]) [= default][output] [, @parameter_name datatype [(length) | (precision [, scale])