SQL语句大全：珍藏版.pdfVIP

SQL -- -- SELECT -- INSERT -- DELETE -- UPDATE -- - CREATE TABLE -- DROP TABLE -- ALTER TABLE -- CREATE VIEW -- DROP VIEW -- CREATE INDEX -- DROP INDEX -- CREATE PROCEDURE -- DROP PROCEDURE -- CREATE TRIGGER -- DROP TRIGGER -- CREATE SCHEMA -- DROP SCHEMA -- CREATE DOMAIN -- ALTER DOMAIN -- DROP DOMAIN -- -- GRANT -- DENY -- REVOKE -- -- COMMIT -- ROLLBACK -- SET TRANSACTION -- --SQL DECLARE -- EXPLAN -- OPEN -- /ttcc2009 FETCH -- CLOSE -- PREPARE --SQL EXECUTE --SQL DESCRIBE -- declare @id char(10) --set @id = select @id = @@ --IF ELSE declare @x int @y int @z int select @x = 1 @y = 2 @z=3 if @x @y print x y -- x y else if @y @z print y z else print z y --CASE use pangu update employee set e_wage = case else e_wage*1.05 end --WHILE CONTINUE BREAK declare @x int @y int @c int select @x = 1 @y=1 /ttcc2009 while @x 3 begin print @x -- x while @y 3 begin select @c = 100*@x + @y print @c -- c select @y = @y + 1 end select @x = @x + 1 select @y = 1 end --WAITFOR -- 1 2 3 SELECT wai select * from employee -- 11 8 SELECT select * from employee ***SELECT*** select *() from table_name() where column_name operator value ex:() select * from stock_information where stockid = str(nid) stockname = str_name stockname like % find this % stockname like [a-zA-Z]% ([]) stockname like [^F-M]% (^) like where ) or stockpath = stock_path or stocknumber 1000 and stockindex = 24 not stock*** = man stocknumber between 20 and 100 stocknumber in(10,20,30) /ttcc2009 order by stockid desc(asc) desc- asc- order by 1,2 by stockname = (select stockname from stock_information where stockid = 4) select