sql92语句(国外英语资料).doc

sql92语句(国外英语资料) SQL 92 standard 2008-03-17 20:02-- statement function -- data manipulation SELECT -- retrieve data rows and columns from a database table When searching by date condition: select *, from, mytab3, where, F4, 10/1/1980 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 -- 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 -- data control GRANT - Grant user access rights DENY - deny user access REVOKE - relieves user access rights - transaction control COMMIT - end the current transaction ROLLBACK - aborts the current transaction SET TRANSACTION - defines the current transaction data access feature - 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 Local variables Declare @id char (10) --set @id Select @id -- global variables At the beginning of --IF ELSE - to @ @ Declare, @x, int, @y, int, @z, int Select @x = 1, @y = 2 @z=3 If @x @y