Tags: data, null

News (3)

Flaws found in open source codes

A project funded by the US Department of Homeland Security has praised improvements in open source security, while outlining some common errors. Read more »

DDoS hole found in powerplant software

A hole has been found in software used by critical national infrastructure organisations including oil, gas and power companies that could lead to a successful denial-of-service attack. Read more »

In T-SQL, use CASE...WHEN in place of IF...THEN

Add some flexibility to your program flow in T-SQL with the CASE...WHEN statement. Get a hands-on look at the statement's syntax and the advantages it can provide for your application. Read more »

Features (155)

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. Learn how to control null data in Oracle using the ORDER BY clause. Read more »

Working with null values in .NET

One of the trickier aspects of application development is dealing with null or nonexistent data. Tony Patton takes a closer look at null values in the .NET framework. Read more »

Avoid Null value conflicts in Access, SQL Server

Null errors between Access and SQL Server can be avoided if you know which functions are platform-specific and which can survive the transition. Read more »

Strategies for approaching null values with SQL Server

Dealing with null values is a fact of life for every database developer. Take advantage of these tips to properly deal with them in SQL Server for your next project. Read more »

The importance of design symmetry in your Java types

Design symmetry means that if one method causes an effect, the logically opposite method should cause the opposite effect. While this can be a subtle point the results may be very significant. Read more »

Send binary data in XML

You may be familiar with using text to describe data in XML files, but what if you want to send binary data? Find out what XML characters will derail binary data and how you can work around the problem. Read more »

Bulk importing data into SQL Server

If you work with databases, at some point, you'll deal with inserting data into SQL Server from outside data files. This tutorial shows how to import data using the BULK INSERT command and explains how changing some of its options can make it easier and more efficient to insert data. Read more »

Download files over the Web with .NET's WebClient class

The System.Net namespace includes the WebClient class for uploading and downloading files via HTTP. You can copy or read files with only a few lines of code. Read more »

Defining cascading referential integrity constraints in SQL Server

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point. Read more »

Ensure data integrity with validation

The many languages available for working with the .NET Framework make it easy to develop code that validates data. Find out what type of data checks you need to perform to ensure data integrity. Read more »

Log in


Sign up | Forgot your password?

What's on?