INSERT can be used in different ways. The following examples will guide you the method of row constructions using INSERT. CREATE TABLE Test1( Column1 INT,
SQL Server – Foreign Key Relationships
To establish a connection between two or more tables, foreign key constraint will be used. One table’s primary key column can be referred to another
SQL Server – GETDATE(), CURRENT_TIMESTAMP in DEFAULT statements
Most of the transactional tables generally do require to have a column with DEFAULT value as current date time to identify when the transaction had
SQL Server – CASE Function- Examples
This article talks about an equivalent of Oracle SQL’s DECODE function in SQL Server. There is no such function in SQL Server but through CASE
SQL Server – Working with Duplicate Records
The following examples deals with how to retrieve or find duplicate records and how to remove them in various scenarios. Someone has asked me that
Introduction to Databases – DBMS History
When I was asked to write something on ORDBMS, I thought it would be better to explain RDBMS first. While I am writing about RDBMS,
Big Data & SQL 