eprintid: 37 rev_number: 12 eprint_status: archive userid: 3 dir: disk0/00/00/00/37 datestamp: 2009-08-06 19:29:55 lastmod: 2016-05-27 21:03:09 status_changed: 2009-08-06 19:29:55 type: conference_item metadata_visibility: show item_issues_count: 0 creators_name: Specht, Jerry title: Some Useful SQL ispublished: pub subjects: aleph divisions: naaug abstract: The SQL INSERT command can be used to create and load records, and copy records to temporary copies of tables. SQL commands can also be used to join a table to itself to locate/correct certain duplicate conditions. This session will explain how INSERT and other useful SQL commands work and give examples of some practical applications in the ALEPH system. Ample time will be given for questions and discussion, and you are encouraged to bring SQL tips of your own to share. date: 2005-06-07 date_type: published full_text_status: restricted pres_type: paper event_title: North American Aleph User Group Sixth Annual Meeting event_location: University of Maryland, College Park event_dates: June 5-7, 2005 event_type: conference refereed: TRUE citation: Specht, Jerry (2005) Some Useful SQL. In: North American Aleph User Group Sixth Annual Meeting, June 5-7, 2005, University of Maryland, College Park. document_url: https://documents.el-una.org/id/eprint/37/1/naaug-2005-specht.pdf