Top SQL tips
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started.
20 SQL tips
| >> | SQL vs. DDS -- The good, the bad and the downright ugly TIP :What does DDL offer over DDS and vice versa? Let's take a look. |
| >> | Use SQL views to transfer packed data using FTP TIP :Here's an easy way to transfer packed data from an iSeries to an ASCII system. |
| >> | Run SQL statements from the command line TIP :Here's a quick way to evaluate information, such as mathematical formulas or file content, etc. |
| >> | SQL recursive REPLACE command TIP :Here's a SQL REPLACE() function that works like TRIM or SUBSTRING. |
| >> | Quickly find SQL error message descriptions TIP :Here's an easy method to learn details about those pesky and cryptic SQL error message codes. |
| >> | Use SQL to delete duplicate records TIP :This short command will delete duplicate keys in SQL. |
| >> | Find the maximum record count using SQL TIP :Retrieve the maximum count of the record using SQL. |
| >> | Use the SQL Rename command to make everyone happy TIP :Working with the SQL Rename command. |
| >> | How to update iSeries databases using JDBC, SQL TIP :The techniques detailed here will help you develop more efficient Java database applications. |
| >> | Using "exception join" in SQL TIP :SQL's "exception join" syntax is rarely understood and even more rarely used. |
| >> | Why do I keep getting SQL error SQL0204? ASK THE EXPERTS :I have written a user SQL function in which I make acall to a C program. When I try to use it, I obtain an SQL error ... |
| >> | SQL has stopped selecting records ASK THE EXPERTS :We have an application that uses SQL to select therecords for a report. The application has been working with over 50 ... |
| >> | Possible to improve SQL query speed? ASK THE EXPERTS :SQL query is faster at second run because files are already loadedinto memory and thus there is no I/O. How ... |
| >> | Advantages of SQL on the iSeries ASK THE EXPERTS :How fast is SQL on the iSeries, and what are the advantages and disadvantages of using SQL on the iSeries? |
| >> | Creating a date field using SQL ASK THE EXPERTS : I've created a table using SQL with a date field. I've used STRPDM to view the data in the date field and found ... |
| >> | Create a table using SQL
via businessanalysis |
pic via photobucket
10+ tips for working smarter with SQL
1: Working with Jet SQL in the Access SQL window
2: Words reserved by SQL
3: The difference between ALL, DISTINCT, and DISTINCTROW
4: Retrieving only what you need
5: Variations in aggregates
6: GROUP BY considerations
7: Altering table structure
8: SQL’s problem child, INSERT INTO
9: Using UPDATE to delete values
10: Dropped properties with SELECT INTO
via techrepublic