SQLBefehle von Fox Pro Grundlagen der SQLProgrammierung mit
SQL-Befehle von Fox. Pro Grundlagen der SQLProgrammierung mit Microsoft Visual Fox. Pro Wizards & Builders Gmb. H
Diese Schulung dient zur Einführung in die Grundlagen der Standard Query Language (SQL) und deren Anwendung in Microsoft Visual Fox. Pro Wizards & Builders Gmb. H
Themenübersicht Defintionen l CREATE TABLE l ALTER TABLE l SQL-SELECT l Wizards & Builders Gmb. H
Umfangreichere Befehle l USE Ø Norequery, Nodata Ø Online, Admin CREATE TABLE l ALTER TABLE l SQL-SELECT l Ø WHERE, GROUP/HAVING, JOINS Wizards & Builders Gmb. H
SQL-Historie n in den 70 ern von IBM entwickelt n 1986 1. ANSI Standard n 1987 ISO Standard n 1989 2. ANSI Standard, Level I und II n 1992 3. ANSI Standard, SQL 2 n an SQL 3 wird zur Zeit gearbeitet Wizards & Builders Gmb. H
SQL-Create l l l CREATE TABLE Table. Name 1 NAME Long. Table. Name [FREE] (Field. Name 1 Field. Type (n. Field. Width , n. Precision) NULL | NOT NULL CHECK ERROR c. Message. Text 1 DEFAULT Wert PRIMARY KEY | UNIQUE REFERENCES Table. Name 2 TAG Tag. Name 1 NOCPTRANS FOREIGN KEY e. Expression 4 TAG Tag. Name 4 [NODUP] FROM ARRAY Array. Name Wizards & Builders Gmb. H
SQL-Alter. Table l l l l ALTER TABLE Table. Name 1 [ADD / ALTER / DROP [COLUMN] Field. Name 3] [SET CHECK l. Expression 3 [ERROR c. Message. Text 3]] [DROP CHECK] [ADD PRIMARY KEY e. Expression 3 TAG Tag. Name 2] [DROP PRIMARY KEY] [ADD UNIQUE e. Expression 4 [TAG Tag. Name 3]] [DROP UNIQUE TAG Tag. Name 4] [ADD FOREIGN KEY [e. Expression 5] TAG Tag. Name 4 REFERENCES Table. Name 2 [TAG Tag. Name 5]] [DROP FOREIGN KEY TAG Tag. Name 6 [SAVE]] [RENAME COLUMN Field. Name 4 TO Field. Name 5] [NOVALIDATE] Wizards & Builders Gmb. H
SQL-Select l l l l SELECT [ALL | DISTINCT] [TOP n. Expr [PERCENT]] [Alias. ] Select_Item [AS Column_Name] FROM [FORCE] [Database. Name!]Table [Local_Alias] [[INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN Database. Name!]Table [Local_Alias] [ON Join. Condition …] [[INTO Destination] [TO FILE [ADDITIVE] | TO PRINTER [PROMPT] [PREFERENCE Preference. Name] [NOCONSOLE] [PLAIN] [NOWAIT] [WHERE Join. Condition [AND / OR Join. Condition. . . ] [GROUP BY Group. Column [, Group. Column. . . ]] [HAVING Filter. Condition] [UNION [ALL] SELECTCommand] [ORDER BY Order_Item [ASC | DESC] Wizards & Builders Gmb. H
Vielen Dank! Das waren die Themen: l Historie l CREATE l ALTER TABLE l SELECT Wizards & Builders Gmb. H
Wenn Fragen bestehen: Wizards & Builders Methodische Software. Entwicklung Gmb. H Frankfurter Str. 21 b 61476 Kronberg Tel. : 06173 -950906 Fax: 06173 -950907 CIS: 101605, 175 Wizards & Builders Gmb. H
- Slides: 10