SQL数据库字典(国外英语资料).docVIP

SQL数据库字典(国外英语资料) Take things as they come. The caged, an unfaithful to husband. Small wind clusters of waves, scattered as stars. Thirty fame dust and soil, eight thousand miles. Squandering charming eyes, can not Asakusa horseshoe. *******************Transact_SQL******************** - 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 =1001