transact sql null date

By following Oded's comments, I got rid of the COALESCE statement and ...

By following Oded's comments, I got rid of the COALESCE statement and set the @flag value to NULL as opposed to NULL. By change this line.

⬇ Download Full Version

I'm writing a TSQL procedure using a CASE statement to display a NULL ...

I'm writing a TSQL procedure using a CASE statement to display a NULL date represented as ' ' as a '' string but having no success. I've tried IS NULL, direct comparisons, using DATEDIFF and comparing against GETDATE(), and CASTing the value to nvarchar and NULL datetime field. Is it possible?

⬇ Download Full Version

You could use a case statement: INSERT INTO [dbo].Production SELECT [field1...

You could use a case statement: INSERT INTO [dbo].Production SELECT [field1],[field2],CASE WHEN cast([datefield] as datetime).

⬇ Download Full Version

Transact-SQL now i whant to change this enddate with NULL Kalman Toth, Micr...

Transact-SQL now i whant to change this enddate with NULL Kalman Toth, Microsoft Community Contributor ; SQL GRAND  insert a null value into a date field.

⬇ Download Full Version

Syntax; Arguments; Result Types; Return Code Values; Remarks; Examples; Exa...

Syntax; Arguments; Result Types; Return Code Values; Remarks; Examples; Examples: Azure SQL Data Warehouse and Parallel Data.

⬇ Download Full Version

When writing T-SQL, a lot of developers use either COALESCE or ISNULL in or...

When writing T-SQL, a lot of developers use either COALESCE or ISNULL in order to provide a default value in cases where the input is NULL. with the following error, since you can't implicitly convert a DATETIME to INT.

⬇ Download Full Version

Hello: Below is my T-SQL view. When DocumentDate is blank, it is When Close...

Hello: Below is my T-SQL view. When DocumentDate is blank, it is When CloseDate is blank, it is NULL. How can I make these.

⬇ Download Full Version

I have Datetime field in my table which is set to NULL. Now, when I An empt...

I have Datetime field in my table which is set to NULL. Now, when I An empty string is not a null value in SQL Server. Ah, didn't know that.

⬇ Download Full Version

If the CreateDate is NULL, then we will use a default date. SELECT COALESCE...

If the CreateDate is NULL, then we will use a default date. SELECT COALESCE([LastUpdateDate],[CreateDate],'1/1/') AS [LastUpdateDate].

⬇ Download Full Version

Clear explanations and tutorial exercises are provided on assigning NULL US...

Clear explanations and tutorial exercises are provided on assigning NULL USE FyiCenterData; GO -- assign NULL values to variables DECLARE @birth_date DATETIME; Introduction To Transact-SQL Language Basics and Data Types.

⬇ Download Full Version

The Three-Valued Logic of SQL has its uses but can cause but the customer s...

The Three-Valued Logic of SQL has its uses but can cause but the customer still knows that date, so it is hardly unknown, nor is it any less applicable. Developers who don't understand how NULL works will sometimes.

⬇ Download Full Version

Inserting NULL in a Date field in SQL Server SQL-Server Set a different def...

Inserting NULL in a Date field in SQL Server SQL-Server Set a different default value if you don't want a null date to be saved.

⬇ Download Full Version

This SQL Server tutorial explains how to use the IS NOT NULL condition in S...

This SQL Server tutorial explains how to use the IS NOT NULL condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server.

⬇ Download Full Version

Here is the sql I wrote to get around the null date. However it won't ...

Here is the sql I wrote to get around the null date. However it won't work, because the date is returned as a string. ISNULL(CAST(Request.

⬇ Download Full Version

NET to execute T-SQL stored procedures with optional named In this stored p...

NET to execute T-SQL stored procedures with optional named In this stored procedure, the only input parameter is a date that has the new.

⬇ Download Full Version