null value

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » null value

null value

Rate Topic

Display Mode

Topic Options

Author

Message

saputra.budi

Posted Wednesday, December 12, 2012 2:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 2:48 AM
Points: 3, Visits: 7

is there many type off null value?
i have table that have null value on 1 of my field.
ex:
id | Name | Info
----------------
01 | A | X
02 | B | null
03 | C | Y

when i try to select all data with null value on info, it didnt show any data or no data in the result.
but when i select all data, there is some data with null value.
i have try selecting with null, 'null', and '' but nothing works.
it happen on 1 of my table. with other table i can selecting data with null value without any problem.

thanks.

Post #1395534

anthony.green

Posted Wednesday, December 12, 2012 3:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

SELECT * FROM table WHERE info IS NULL

A NULL value can not be used in an equals operation as SQL doesnt know if NULL is < > or = to the value you want to compare it to, therefore you must treat is with IS NULL to or wrap the null column in ISNULL() which will then provide a value to the NULL column.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1395540

Bhuvnesh

Posted Wednesday, December 12, 2012 3:20 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

it seems that you are unaware of NULL keyword , take help from here
http://www.techrepublic.com/blog/datacenter/handling-null-values-in-sql-server-2005/153
PLUS
you query will work like this

select * from  table where info is null

BUT below wont work

select * from  table where info = null

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1395548

« Prev Topic | Next Topic »

Permissions