Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Understand the effects of NULLs on inner and outer JOINs
- For reader clarificationFor reader clarification, the reason you cannot join the value 1 with the value NULL is becuase the value NULL is unknown. You, and the system for that matter, will not know the value NULL until an explicit value is entered
- Tags: tim chapman, Value at Risk, software, NULL, NULL VALUE, NULLS, chapman.tim@..., foreign key
- Discussion threads 2006-11-28
Additional Resources
- How do I... Generate a running total in an Access query?
- Have you had success using this query technique? What are some other workarounds you use on a regular basis?Do not use this techniqueon a big table, well not unless it's a convenient time for a coffee break. Beware of nulls in the data you ar
- Tags: Databases, JodyGilbert
- Discussion threads 2006-12-04
- 10 questions to ask yourself before optimizing your database
- When the time comes to optimize your databases, you want to ensure that you're up for the job. Avoid optimization missteps and learn about a product that will help you eliminate these errors in the first place. You may not be taking advantage of all the little things you...
- Tags: SQL, Databases, Arthur Fuller, Enterprise software, data type, database, SQL Server Newsletter, TechRepublic Inc., Column, SSW, SQL Auditor, Storage, Programming Languages, Software, Data Management, Hardware, Software Development, Software/Web Development
- Technical articles 2005-08-22
- Control null data in Oracle using the ORDER BY clause
- Related Tip (SQL*Plus Only)On a related point, I used to have problems distinguising between result sets with spaces in certain columns, and nulls in those columns (esp. when I wasn't ordering by them). Then I actually read Johnathan Gennick's book, and discovered that all I had to do was...
- Tags: psinger1, Oracle Corp.
- Discussion threads 2007-06-20
- MSDN Webcast: What I Wish Developers Knew About Writing Applications for SQL Server 2005 (Level 200)
- This webcast addresses some of the most common errors in SQL server encounter, and explains how to avoid them in the applications. The speaker covers connecting to SQL Server, cursors, handling NULLs, stored procedures and dynamic SQL, error handling, and transactions.
- Tags: Developer, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- Webcasts
- Understand the effects of NULLs on inner and outer JOINs
- In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs. SQL Server developers must understand two things: the difference between inner and outer JOINs and the effect of NULLs upon these choices. This tip ...
- Tags: Human Resources, Row, Column, Databases, Arthur Fuller, Network technology, SQL Server Newsletter, Networking, Enterprise Software, Software, Data Management
- Technical articles 2006-11-28
- 10 questions to ask yourself before optimizing your database
- "Standard Columns"?Tip 8 mentions "Standard Columns". Is this in Enterprise Mananger, Query Analyzer or somewhere else? I can't find it and I'm not sure what it is. ThanksGreat QuestionsGreat Questions. What are the answers?Anyone reads this comments?where is the Standard Columns?Thanksagreed, how about answersI agree that...
- Tags: Char, database, MetroMark, software, sql server, Standard Columns
- Discussion threads 2005-08-23
- Control null data in Oracle using the ORDER BY clause
- NULL data, which is sometimes called "absent" data, can be difficult to work with in relational databases. When a query contains the ORDER BY clause to sort the output, NULL data will sort to the bottom if the sort is in ascending order ASC and to the top if the...
- Tags: oracle, databases
- Blog posts 2007-06-19
- I Need Help with access query
- I have a table of student records they pay their fees in three instalments entered in the table as Payment1 Payment2 and payment3. To compute the balance paid by a student i created a calculated field that sums up all the payments and deduct from the Total course fee. I...
- Tags: amalijohn@...
- Discussion threads 2004-10-14
- Updating SQL Server table changes
- blog rootWhat's the best way?The blog introduction basically states the problem. I have not been doing SQL very long and all my knowledge is OJT. We use SQL Server 2000 at all the sites. Now I just have to try to figure out a way to update a customers database...
- Tags: Blogging, Programming languages, Databases, hhambrick, server, blog, Microsoft SQL Server
- Discussion threads 2005-12-14
- Vague Ethernet standard exposes sensitive data on many networks
- Researchers from @stake have discovered a vulnerability that has been slowly bleeding sensitive data across networks for more than a decade.The report from @stake, "EtherLeak: Ethernet frame padding information leakage," indicates that the threat derives from the fact that some Ethernet device drivers have been padding small Ethernet packets with...
- Tags: @stake Inc., CERT, device driver, Ethernet, John McCormick, network, null, sensitive data, vulnerability
- Technical articles 2003-01-27
- SDI LPD (exe)
- Fast and easy LPD print server for Windows. SDI LPD prints reports from IBM zSeries mainframe, iSeries (AS/400), and Unix systems on your Windows local or network printers. Handles TCP/IP network printing for LAN, WAN, or the Internet. Version 2.5.0e adds print nulls option to the print queue setup dialog;...
- Tags: Printing, Printers, Microsoft Windows, Document Management, Mainframes, Servers, Networking, Hardware, Peripherals, Operating Systems, Software, Enterprise Software, Finance, Managerial Accounting
- Software downloads 2006-06-07
- SQL Svr 2000: Replicate table structure
- Fairly new to SQL, all OJT. Need to come up with the best method of updating customer databases with table structure changes that have been made in an application. Already have a method of generating a script that will add any new columns to their tables for any...
- Tags: Databases, database
- Discussion threads 2005-12-14
- Access 03 odbc call: data over two forms
- Hi,Basically i have a form with some fields on; after fillingin the required and saving the user has an option to continue to fill more data on a second form.The form is opened and the ID number is copied from the original hence the need to save first this then...
- Tags: first form, Microsoft Access, monkeybasket2001@..., ODBC, software
- Q&A 2005-12-12
- Access database basics
- I am new to databases--I have an Access database that that matches vehicle numbers from a workorder to obtain the type and billing amounts. The query works fine, except I don't know how to make a separate report for those vehicle numbers on the workorder that do not match the...
- Tags: access, database, Microsoft Access, sean@..., software, SQL, workorder
- Discussion threads 2007-01-20
- Oracle Tip: Understand how NULLs affect IN and EXISTS
- On the surface, it may appear that the SQLclauses IN and EXISTS are interchangeable. However, they're quitedifferent in how they handle NULL values and may give differentresults. The problem comes from the fact that, in an Oracledatabase, a NULL value means unknown, so any comparison oroperation against a NULL value...
- Tags: Databases, Oracle Corp., IS NULL, clause
- Technical articles 2004-08-22
- How to properly use method overloading in Java
- Don't mess with the meaning of the parametersWhen I saw:PersonString lname {...Person(String fname, String lname) {I cringed. As a rule changing the meaning of the parameters like this is not a good thing. It leads to problems like coding:Person p2 = new Person("Patton");Person p3 = new Person("Patton", "Tony");Is...
- Tags: Development tools, constructor
- Discussion threads 2005-11-11
- Compare records in 2 tables and move data from one table to the other
- I have two tables with 3 columns in common: FirstName, LastName, Department. Table A Access table has additional columns (RecordID, Address, Phone, etc. This table is missing data in the some of the records in the Department field.Table B an Excel spreadsheet is missing no data in any...
- Tags: Microsoft Office, Table
- Discussion threads 2005-08-11
- Oracle9i simplifies SQL syntax
- Oracle9i SQL includes major improvements over previous versions. Learn more with a detailed discussion of the enhancements, including sample code.Oracle has made some important enhancements to Oracle9i SQL, including a host of exciting new execution plans, support for scalar subqueries, and support for the ISO 99 SQL standard. As implemented...
- Tags: Databases, Programming languages, Enterprise software, Oracle9i SQL, Donald Burleson, SQL, CROSS JOIN, Oracle9, Oracle Corp., Oracle9i
- Technical articles 2002-08-02
- Differences between Jet's IsNull() and T-SQL's COALESCE() functions
- By Susan Sales Harkins and Doris ManningFailure to contemplate possible null values and handle them properly can lead to runtime errors, or even worse, bad data—and you really don't want your users and clients to experience either at your expense.Null values present a special problem for Access and SQL Server...
- Tags: Scripting languages, Databases, Microsoft SQL Server Transact-SQL, Guest Contributor, Iif, N/A, VBA
- Technical articles 2003-08-07
- << Previous
- page 1 of 1
- Next >>
