ocdatabases.blogspot.com
Orange Coast Database Associates: CASE expressions
http://ocdatabases.blogspot.com/2012/09/case-expressions.html
Sunday, September 9, 2012. There are times when you want to pick one of several alternatives for a field in your select list. The examples we are going to use are from our bookstore database ( click to download at box.com. CASE selector when expr1 then value1 when expr2 then value2 . when exprN then valueN else value 3. The else clause is optional. The alternative is selected based on the value of the selector. CASE when expr1 then value1 when expr2 then value2 . when exprN then valueN else value 3.
ocdatabases.blogspot.com
Orange Coast Database Associates: Supplier-Parts Database SQL Script
http://ocdatabases.blogspot.com/2012/04/supplier-parts-database-sql-script.html
Saturday, April 14, 2012. Supplier-Parts Database SQL Script. SNUM int NOT NULL PRIMARY KEY,. SNAME varchar(16) NOT NULL UNIQUE,. STATUS int NOT NULL,. CITY varchar(20) NOT NULL. PNUM int NOT NULL PRIMARY KEY,. PNAME varchar(18) NOT NULL,. COLOR varchar(10) NOT NULL,. WEIGHT decimal(4,1) NOT NULL,. CITY varchar(20) NOT NULL,. UNIQUE (PNAME, COLOR, CITY). SNUM int NOT NULL REFERENCES Suppliers,. PNUM int NOT NULL REFERENCES Parts,. QTY int NOT NULL,. PRIMARY KEY (SNUM, PNUM). INSERT INTO SupplierParts VAL...
en.wikipedia.org
Joe Celko - Wikipedia, the free encyclopedia
https://en.wikipedia.org/wiki/Joe_Celko
From Wikipedia, the free encyclopedia. Is an American relational database. Expert from Austin, Texas. He has participated on the ANSI. X3H2 Database Standards Committee, and helped write the SQL. 89 and SQL-92 standards. He is the author of a Morgan-Kaufmann. Series of books on SQL, and over 1200 published articles on SQL and other database topics. He had been a full-time statistician for several years. He is credited with coining the term lasagna code. And popularizing Michael J. Kamfonas. He has taught...
ocdatabases.blogspot.com
Orange Coast Database Associates: Left Outer Join
http://ocdatabases.blogspot.com/2012/06/left-outer-join.html
Tuesday, June 5, 2012. This post shows how to create a left outer join. Outer joins are often used in reporting. It also shows how to modify the outer join to create a "find unmatched" query. Left - all matched rows plus unmatched from the "left" table. Note that left refers to reading order. It means the first table mentioned in the query, the one to the "left". Full- not often seen. Adds unmatched from both left and right tables. Left Outer Join Syntax. Left [outer] join table2. Left [outer] join table2.
codeinet.blogspot.com
Code.I.net: 2006-08
http://codeinet.blogspot.com/2006_08_01_archive.html
Codeine is a drug which is used to relieve pain, especially headaches. .Net is a (Micro)soft drug to induce pain, especially headaches. Delphi programming. Is it a plane? Is it a . No it's SQLMan! Rader than " SQL programming Style. The powers of SQL takes decenniums to master, in the wrong unexperienced hands it may be a totally disaster. Luckily SQLman is here now! Read about he's ongoing fight against the unlighted here. This post was inspired by this. Post by Ken Henderson . Links to this post. Table...
ocdatabases.blogspot.com
Orange Coast Database Associates: April 2012
http://ocdatabases.blogspot.com/2012_04_01_archive.html
Saturday, April 14, 2012. Supplier-Parts Database SQL Script. SNUM int NOT NULL PRIMARY KEY,. SNAME varchar(16) NOT NULL UNIQUE,. STATUS int NOT NULL,. CITY varchar(20) NOT NULL. PNUM int NOT NULL PRIMARY KEY,. PNAME varchar(18) NOT NULL,. COLOR varchar(10) NOT NULL,. WEIGHT decimal(4,1) NOT NULL,. CITY varchar(20) NOT NULL,. UNIQUE (PNAME, COLOR, CITY). SNUM int NOT NULL REFERENCES Suppliers,. PNUM int NOT NULL REFERENCES Parts,. QTY int NOT NULL,. PRIMARY KEY (SNUM, PNUM). INSERT INTO SupplierParts VAL...
ocdatabases.blogspot.com
Orange Coast Database Associates
http://ocdatabases.blogspot.com/2012/06/there-is-way-to-represent-schema-of.html
Tuesday, June 26, 2012. We can represent this in text with a few conventions: bold for a required field. And underline for primary key. List the table name and then the field names in parentheses.This yields the text schema below. Note the composite primary key in the labor table. Each column is also a foreign key. You might find this technique useful if dashing off a quick Email or you are without your favorite drawing tools. Subscribe to: Post Comments (Atom). View my complete profile.
ocdatabases.blogspot.com
Orange Coast Database Associates: About Us
http://ocdatabases.blogspot.com/p/about-us.html
Orange Coast Database Associates, Inc is a small database training and programming group serving Southern California. Our business office is in Laguna Niguel and our training facility is in nearby San Juan Capistrano. Both are just inland from the beach cities of Laguna Beach and Dana Point. This places us about midway between the Los Angeles and San Diego metropolitan areas. In addition to the above we can provide training for the Adobe products on-site at your faciltities. Subscribe to: Posts (Atom).
