What is the datatype of null?

Questions by kvmahesh99

Showing Answers 1 - 33 of 33 Answers

Sharanjit kaur

  • Nov 29th, 2013
 

String

  Was this answer useful?  Yes

Amandeep

  • Mar 18th, 2015
 

Its INT. You can use the below query
SELECT x = NULL INTO #x;
EXEC tempdb..sp_columns #x;

  Was this answer useful?  Yes

Ayushi

  • May 7th, 2015
 

Null has no datatype in SQL. It is untyped in SQL

  Was this answer useful?  Yes

Ravi Sharma

  • Jun 2nd, 2015
 

Null is undefined. We cannot compare 2 NULL values.

  Was this answer useful?  Yes

Srinivas

  • Jul 9th, 2015
 

The Null value is Undefined value and dont have any datatype for SqlDataBase.

  Was this answer useful?  Yes

Ravindra Kumar Singh

  • Jan 16th, 2017
 

Null is not a datatype because we can't typecast null values. The memory occupied by null is 2 byte.

  Was this answer useful?  Yes

kamnagarg

  • Feb 2nd, 2017
 

As per docs.oracle :
Oracle Database currently treats a character value with a length of zero as null. However, this may not continue to be true in future releases, and Oracle recommends that you do not treat empty strings the same as nulls.

  Was this answer useful?  Yes

Dhileep

  • Oct 24th, 2017
 

We cant able to mention particular data type for null.

  Was this answer useful?  Yes

Sudha

  • Apr 2nd, 2018
 

NULL is not a data type. The key word NULL is used to mention the unknown or missing values of data.
For ex: while registering sign up form there are few fields which are not mandatory and if user didnt fill those non mandatory fields then those values we can save it as null in the data table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions