Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 10 tricks for handling null values in Microsoft Access
- This article is also available as a PDF download.Where errors are concerned, null values are an equal-opportunitymenace. If an unhandled null value doesn't generate a runtime error, it'll showup in erroneous data. Neither problem is your run of the mill "oops, there's abug" error. In fact, an unhandled null value...
- Tags: IS NULL, IsNull, Microsoft Access, Microsoft Corp., Susan Harkins, Value at Risk
- Technical articles 2006-10-12
- Exploring the various uses of SQL's CASE keyword
- SQL's CASE keyword is useful in a variety of situations beyond merely selecting custom columns. Discover how you can use CASE to deliver grouped and ordered result sets that you might have thought were impossible. The CASE keyword may be one of the most underused keywords in SQL....
- Tags: SQL, Arthur Fuller, IS NULL, SQL Server Newsletter, TechRepublic Inc., Price, CASE, GO SELECT CASE, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-21
- Optimization of sql statements
- SELECT notificationid, a.status, notificationrefno, (SELECT COUNT (*) FROM company com WHERE a.forcompanyid = com.parentcompanyid) AS parentindicator, companyname, transactionid, refamount, refcurrency, ...
- Tags: Category, IS NULL, b.NOTIFICATIONTYPEID, rumanapunawala@..., programming, SQL, DESC, notificationType
- Q&A 2006-05-01
- Exploring the various uses of SQL's CASE keyword
- Sql's Case KeywordVery usefulShowing Description in Group by clauseIn group by example, try the following querySELECT CASE WHEN price IS NULL THEN 'Unpriced' WHEN price < 10 THEN 'Bargain' ...
- Tags: CASE, END, IS NULL, ramasubramanianm@..., software, SQL, sql server
- Discussion threads 2005-08-30
- 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
Additional Resources
- 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
- 10 tricks for handling null values in Microsoft Access
- Have you ever run into problems caused by someone who neglected to accommodate null values? Are there any additional situations where you've had to work around or proactively handle null values to prevent errors?HmmWhere not(source.field) is null
- Tags: 10 things, JodyGilbert, Microsoft Access, Microsoft Corp., Null, software, sql, susan harkins
- Discussion threads 2006-10-12
- Evaluating Oracle Null Date in Crystal
- I am using Crystal Reports in Visual Studio 2003.I am unable to evaluate a null date/time in a formula field. All I want to do is :If date is null then "No" else "Yes";My unsuccessful attempts :1. "Is Null" errors out looking for a "Then" even...
- Tags: Crystal, Crystal Reports, Oracle Corp., programming, SpiderDad
- Q&A 2005-10-21
- Include Null values in calculated queries in Access
- About the NZ functionNZ is one of those VBA function that can be used when building expressions in the query grid.Although NZ stands for Null to Zero it can return another value too. Add a second parameter to NZ and specify the value returned if Null. Can be a number...
- Tags: Microsoft Access, daniel@..., Nz Function
- Discussion threads 2007-11-24
- Virtual Null Modem (exe)
- To emulate null-modem connection Virtual Null Modem can be effectively used. The program emulates one or more couples of RS-232 serial ports connected via virtual null-modem cable. It is possible to create the unlimited couples of VSP on a single PC without additional hardware and connect them in any sequence...
- Tags: Serial Port, Modems, Cable, Network Technology, Hardware, Components, Telecommunications, Personal Technology, Networking
- Software downloads 2005-08-17
- 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
- null sessions
- I have a problem trying to connect a large format hp printer on my network, i need to add a shared folder into the registry of the network in null sesstions WHERE IS THE REGISTRY FOR NULL SESSIONS? :(
- Tags: andyharrop_11@...
- Discussion threads 2005-08-02
- Finding the highest value in several SQL Server columns
- greatest at leastFiding the highest or lowest values in a row is something that I stumbled upon years ago.In my job I have to handle several RDBMSs, among them MSSQL, Oracle, Postgresql and MySQL.I added a couple of function in my MSSQL library named dbo.least(@n1,@n2) and dbo.greatest(@n1,@n2) since I...
- Tags: philippe.e@..., NULL VALUE, greatest, least, feedback, arg, Microsoft SQL Server, server
- Discussion threads 2007-02-27
- 10 tricks for handling null values in Microsoft Access
- Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you understand and effectively address null values in various situations. Database expert Susan Harkins explains a...
- Tags: Microsoft Access, Microsoft Corp., Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Download resources 2006-10-12
- Save time and prevent coding headaches with nullable types in C# 2.0
- Before C# 2.0, the inability to assign a null value to some types was a headache for developers. This limitation forced developers to come up with their own solutions and workarounds for setting a non-nullable variable to null. In C# 2.0, Microsoft remedies this situation with the addition of nullable...
- Tags: C#, .Net, Programming Languages, Software Development, Software/Web Development
- Download resources 2006-08-03
- SQL in MS Access
- I am looking for help on a specific SQL query in MS Access. I keep running into syntax errors. I have 4 fields in the query. When the data I'm querying is LIKE the data in field 1 AND the data in field 3 and/or 4 IS NULL or BLANK,...
- Tags: Microsoft Office, Databases, kms_cryswater@..., Microsoft Access, Field 3, SQL, Microsoft Corp.
- Discussion threads 2007-07-02
- Understand the inner workings of generics in Java
- mentionnice article.Message was edited by: beth.blakely@...RE: Understand the inner workings of generics in JavaWhen You say "writing non-null elements to the list is not allowed" does it mean You can not write anything but null value to the List ? Or I am missing something...A typoThis is atypo, thanks. What...
- Tags: Programming languages, teksty32@..., Java
- Discussion threads 2007-08-23
- Power Linux with pipes and redirection
- more on redirecting standard output and errorThe order of redirection in the case of redirecting standard output and error is important depending what you want. If say you want to get rid of all messages from a command the correct way is:> /dev/null 2>&1which send all output to the bottomless...
- Tags: Microsoft Windows Vista (Longhorn), Microsoft Windows XP, stomfi@..., Linux, redirection
- Discussion threads 2007-10-16
- Filters for all dates
- Hey,I am using Between and AND to filter the dates in report what I have specified in two testboxes in relevant form. Its working on that but if I leave the textboxes blank. How will I get all the dates. Its showing error. May be Null value.Can anybody help me...
- Tags: jdk@...
- Discussion threads 2007-04-11
- Calculating Access fields with Null values
- Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. by Mary Ann Richardson
- Tags: Microsoft Access, Formula, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-07-01
- << Previous
- page 1 of 1
- Next >>
