Tag Info

Hot answers tagged

5

You can use a date field as a primary key, but you can't key on PART of a field. You'd have to make a separate field with just the date. This particular condition isn't something that would normally be enforced by building it into the primary key of a table anyway. Your "Employee can't work same shift on same date twice even in two locations" is a business ...


4

Selecting means choosing some records from a table and leaving others out. Projecting means choosing some columns from each record and leaving others out. Therefore, your query performs selection (records with name='zeus' are chosen, but others are rejected) but not projection (those records that are chosen are returned with all of their columns). ...


1

Excel files use a string table which "folds together" duplicate entries; if you're willing to do the work, learning the file format and getting to that string table would run much more quickly than launching Excel and etc etc etc. This strategy would have one flaw: it would NOT index strings that were the result of formulas, because those aren't in the ...



Only top voted, non community-wiki answers of a minimum length are eligible