Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Define NULL
- since it came up in a discussion about sql.I figured I would ask here.what is the definition of NULL in sql,c, c++,java,perl,python.and from where do you get this definition?the discussion I'm pulling this querstion from:In SQL, NULL means "unknown value". How could you assert that two NULLs are equal?which doesn't...
- Tags: Define NULL, Jaqui, NULL value, programming, SQL, Value at Risk
- Q&A 2005-01-24
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
- Accommodate Null values in Access queries
- Not getting the results you want can be frustrating. But if the problem is Null values, it's easily resolved. Use a simple expression to include or exclude Null. by Susan Harkins
- Tags: Microsoft Access, Portland, Seattle, Null, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-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
- 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
- Defining SQL Server constraints with TSQL
- Take your database administration skills to the next level by learning how to define constraints with TSQL. This advanced skill shows that you don't always rely on graphical interfaces when designing database objects. All competent DBAs and developers should possess the ability to logically define constraints in the...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, server, SalesHistory, SQL Server Newsletter, Constraint, Column, Table, TSQL, OBJECT_ID, SaleID, SaleDate, SalePrice, Listing D, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-05-07
- Using Oracle's COALESCE function as a quick CASE statement
- DB2This functionality is not limited to Oracle, exists in DB2 SQL as well.....Quite rightThanks for commenting! You're quite right: it's part of the SQL standard. The title of the article was not meant to imply it was an Oracle-specific feature.BobWLooks like Decode to meThis looks almost exactly like Decode to...
- Tags: algorithm, COALESCE, Decode, Oracle Corp., ProblemSolverSolutionSeeker, software, sql, Value at Risk
- Discussion threads 2006-09-27
- << Previous
- page 1 of 1
- Next >>
IP Networking
-
Anywhere, anytime productivity isn’t just for cyber-geeks and overachievers. It’s the state of business today, made possible through integrated wired and wireless networks, secure remote access, and advanced mobile applications and devices. Your users have what they need; do you?
- From our sponsors
-
IT Solutions
-
-
AT&T IP Networking for your IT needs
With AT&T IP Networking, you get flexible solutions designed specifically for your company’s IT needs
Learn more
-
