Top "Isnull" questions

IS NOT NULL and ISNULL( str, NULL ) in WHERE clause

I have three tables (simplified here): recipients: recipientId, isGroup users: userId, first name, last name groups: groupid, groupname I want …

sql sql-server isnull

ISNULL(Count(x),0) not returning 0 when null

I have the following code: SELECT FirstName, LastName, (SELECT ISNULL(COUNT(UP1.EmailAddress), 0) AS HasEmail From dbo.UserProfiles AS UP1 …

tsql coalesce isnull

Peewee syntax for selecting on null field

I have researched this everywhere and can't seem to find an answer. I hope I haven't duplicated this (as it's …

python mysql null isnull peewee

mysql - function like isnull() to check for zero-value

I'm looking for a function to check if a column has the value 0 that behaves like the isnull() function. This …

mysql substring zero isnull

ANSI equivalent of IS NULL

I am trying to find the ANSI way to write the T-SQL 'IS NULL'. (corrected, was 'IN NULL') Some posts …

sql coalesce isnull ansi-sql

How to write IsNullOrEmpty method similar to ISNULL in sql server

I want to have function in sql server similar to ISNULL() except it should check expression for null and empty …

sql-server isnull isnullorempty

Python pandas .isnull() does not work on NaT in object dtype

I have this series: ser=pd.Series([11,22,33,np.nan,np.datetime64('nat')],name='my_series') The series looks like this: 0 11 1 22 2 33 3 …

python datetime pandas isnull

SQL: select all rows if parameter is null, else only select matching rows

I have a variable coming into a stored procedure. This variable can either have a value or be null. If …

sql sql-server-2008-r2 isnull

How does Scala handle isnull or ifnull in query with sqlContext

I have two data files as below: course.txt id,course 1,Hadoop 2,Spark 3,HBase 5,Impala Fee.txt id,amount 2,3900 3,4200 4,2900 I …

sql scala apache-spark isnull

Computed bit column that returns whether another column is null

I try to have this computed column: CREATE TABLE dbo.Item ( ItemId int NOT NULL IDENTITY (1, 1), SpecialItemId int NULL, --I …

sql-server-2005 null calculated-columns isnull