Category Archives: SQL Server Learning

#SQLSERVERLearning : Column Data Type Conversion 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 , , , | 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

#SQLSERVERLearning : CASE Statement Insight

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 SQL Server Learning | Tagged , , , , | Leave a comment

Multiplication across rows and Analytical Functions.

Oracle or SQL Server provide Aggregation functions for MIN/MAX/COUNT/SUM, but suppose a scenario when we want multiplication of rows across a partition or complete table. Database does not provide any buildin function to achieve same. Suppose we have below expectations, … Continue reading

Rate this:

Posted in Helper SQL, Oracle Internal, SQL Server Learning | Tagged , , , , , | 1 Comment

#SQLSERVERLearning : Identity Column Insight.

All my blogs with #SQLSERVERLearning are intended to cover all stuff identified as the 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 … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , , | 1 Comment

#SQLSERVERLearning : Exception on Invalid/Incorrect Hints?

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 findings or Observations with SQL Server … Continue reading

Rate this:

Posted in Oracle Internal, SQL Server Learning | 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

#SQLSERVERLearning : Only Execute Current Statement in SQL Server Mgmt Studio??

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. For complete list of topics on SQL … Continue reading

Rate this:

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

#SQLSERVERLearning : Changing Short Cut in SQL Server for Query Execution.

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. In SQL Developer for running any SQL … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , | 1 Comment

#SQLSERVERLearning : Alias are mandate for inline views

New challenge added to my career life – Microsoft SQL Server.! Now need to work on multiple database along with Oracle (My Fav) as primary. Most of folks feel , both are traditional RDBMS database and should or need to … Continue reading

Rate this:

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