Notice that each variable has extra key words before its declaration: public const public static The keyword public shows us this is a globally accessible variable. When trying to access the variables, note we now have to use the before the name of the MyGlobals. variable we want to use. The use of SQL to search for data Pseudocode (including nested SELECTs) SELECT (including use of wildcard) FROM * WHERE (with used as a wildcard) LIKE % AND OR SQL This example assumes there is a database created called with columns called: ‘Customers’ CustomerID CustomerName ContactName Address City Country. This selects everything (*) from the SELECT * FROM Customers database. Customers This selects the and SELECT ContactName,Address ContactName FROM Customers columns from the Address Customers WHERE ContactName = ‘Mr Jones’; table and then specifically looks for a “Mr in the field. Jones” ContactName This selects the and SELECT ContactName,Address ContactName FROM Customers columns from the Address Customers WHERE CustomerID = 3; table where the CustomerID field equals 3.
Notice that each variable has extra key words before its declaration: public const public static The keyword public shows us this is a globally accessible variable. When trying to access the variables, note we now have to use the MyGlobals. before the name of the variable we want to use. The use of SQL to search for data Pseudocode SELECT (including nested SELECTs) FROM (including use of * wildcard) WHERE LIKE (with % used as a wildcard) AND OR SQL This example assumes there is a database created called ‘Customers’ with columns called: CustomerID CustomerName ContactName Address City Country. SELECT * FROM Customers This selects everything (*) from the Customers database. SELECT ContactName,Address FROM Customers WHERE ContactName = ‘Mr Jones’; This selects the ContactName and Address columns from the Customers table and then specifically looks for a “Mr Jones” in the ContactName field. SELECT ContactName,Address FROM Customers WHERE CustomerID = 3; This selects the ContactName and Address columns from the Customers table where the CustomerID field equals 3.
398694-programming-techniques-c-teacher-guide.docx