sql应用命令实例（SQL application command instance）.docVIP

sql应用命令实例（SQL application command instance） Statement function -- data manipulation 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 -- 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 - must be at the beginning of @ @ --IF ELSE Declare, @x, int, @y, int, @z, int Select @x = 1, @y = 2 @z=3 If @x @y Printx Y- print stringx Y Else, if, @y @z Printy z Else, print,z Y --CASE Use P