Tag Archives: NULL

FIXED length character storage and NULL in SQL Server.

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

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.

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?

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

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