SQL查询语句大全(国外英语资料).docVIP

SQL查询语句大全(国外英语资料) SQL statement Daquan,.Txt iron rice bowl true meaning, not in a place to eat a lifetime of rice, but a lifetime to where there is rice to eat. It is a piece of shit, also have met shikelang day. So you dont have to worry too much about yourself today. SQL query Daquan Statement function 1, data operation Select -- retrieve data rows and columns from a database table Insert -- adding new data rows to a database table Delete -- deletes rows of data from the database table Update -- update the data in the database table 2, data definition Create TABLE - create a database table Drop TABLE -- delete tables from the database Alter TABLE - modify the database table structure Create VIEW - create a view Drop VIEW -- delete views from the database Create INDEX -- creates an index for the database table Drop INDEX -- removes indexes from the database Create PROCEDURE - creates a stored procedure Drop PROCEDURE -- deletes stored procedures from the database Create TRIGGER - create a trigger Drop TRIGGER -- removes triggers from the database Create SCHEMA -- add a new schema to the database Drop SCHEMA -- deletes a schema from the database Create DOMAIN - creates a data range Alter DOMAIN - change domain definitions Drop DOMAIN -- deletes a domain from the database 3, data control GRANT - Grant user access rights DENY - deny user access REVOKE - relieves user access rights 4, transaction control COMMIT - end the current transaction ROLLBACK - aborts the current transaction SET TRANSACTION - defines the current transaction data access feature 5, programmed SQL DECLARE -- sets the cursor for the query EXPLAN -- describes data access plans for queries OPEN -- retrieve the query results and open a cursor FETCH -- retrieve a row of query results CLOSE - close the cursor PREPARE - prepares SQL statements for dynamic execution EXECUTE - dynamically executing SQL statements DESCRIBE -- describes the prepared query 6, local variables Declare @id char (10) --set @id =10