How do I check if a SQL Server datetime column is empty?

How do I chec开发者_JS百科k if a SQL Server datetime column is empty?

Test it with IS NULL.

If using .NET, test against DBNULL.

... WHERE [ColumnName] IS NULL

Or do you mean something else by "empty" that isn't NULL? Does your column allow NULL values? Are you instead looking for some kind of default value?

To get all rows wtih an empty datetime column you could do this:

SELECT * FROM yourtable WHERE yourdatecolumn IS NULL

This worked for me in C# , Where

con is my Sql Connection

SqlCommand cmd = new SqlCommand("Select * From Transactions WHERE TransactionID = '"+tid+ "'AND InDate IS NULL ", con);

net Use IsDBNull or in transact sql use is null.

Just as an alternative to using NULL, you could try:

SELECT * FROM table_name WHERE column_name = '0000-00-00'