Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- SQL basics: Deleting from child tables
- This SQL basics article responds to Builder.com members' questions about deleting rows from one table and using another table as a data reference.I’ve received several requests for a description of how to delete rows from tables that are dependent on criteria from other tables. The solution lies in a clever,...
- Tags: Programming languages, Databases, Shelley Doll, SQL Basics, SQL, subselect
- Technical articles 2002-10-15
- Use SQL subselects to consolidate queries
- Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!Do you ever find yourself juggling queries to get the information you need? Subselects, also called subqueries, may be just what you’ve been looking for. This SQL feature allows you to...
- Tags: Databases, Shelley Doll, Metallica, SQL, result set
- Technical articles 2002-07-15
Additional Resources
- SQL basics: Query multiple tables
- Whether you're learning SQL for the first time or just need a refresher, read this article to learn when to use SELECT, JOIN, subselects, and UNION to access multiple tables with a single statement.It’s sometimes difficult to know which SQL syntax to use when combining data that spans multiple tables....
- Tags: Programming languages, Databases, Shelley Doll, multiple table, SQL, database
- Technical articles 2002-08-12
- Build temporary tables to optimize SQL queries
- You are guruGreat!!!Helpful to add IdentityI have used a variation of this function that implements an Identity column in the temp table. This is useful if the order of the parsed IDs is important. It allows you to sort the parsed IDs ASC / DESC on the order they were...
- Tags: Phoenix Cyan, software, sql, temp table
- Discussion threads 2006-01-10
- << Previous
- page 1 of 1
- Next >>
