Tag Archives: NULL

FIXED length character storage and NULL in SQL Server.

Posted on May 31, 2017 by

Most of us must be aware of CHAR datatype and its fixed length storage pattern. If we declare CHAR(32) and store only 4 bytes character ‘ABCD’, It will pads up remaining bytes (28 bytes). Ultimately, whole bytes is consume for … Continue reading →

Rate this:

Posted in SQL Server Learning | Tagged , , , , | Leave a comment

#SQLSERVERLearning : String Concatenation for NULL and Empty String in Oracle and SQL Server

Posted on December 17, 2016 by

All my blogs with #SQLSERVERLearning is intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for Oracle guy also working in SQL Server world. All finding or Observations with SQL Server … Continue reading →

Rate this:

Posted in Oracle Internal, SQL Server Learning | Tagged , , , , , , | 2 Comments

Aggregate Function , Distinct and NULL Values in Oracle.

Posted on December 1, 2016 by

While working on SQL Server with queries having aggregation got a warning message. “Warning: Null value is eliminated by an aggregate or other SET operation.” So thought let write up something on Aggregation and NULL Values for Tradition RDBMS for … Continue reading →

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment

#SQLSERVERLearning : Does Unique Index Stored NULL Values in Index?

Posted on November 21, 2016 by

All my blogs with #SQLSERVERLearning are intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for any Oracle guy also working with SQL Server. All finding or Observations with SQL Server … Continue reading →

Rate this:

Posted in Oracle Internal, SQL Server Learning | Tagged , , , , , | Leave a comment

NOT IN Condition and NULL Data

Posted on November 24, 2014 by

Before getting into discussions, lets start with a SQL example. Trying to fetch all employees who are not manager! Employee table Structure Name Null Type ——– ——– ———— EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE … Continue reading →

Rate this:

Posted in Oracle Internal | Tagged , , , | 2 Comments