When a new record is added to a table, SQL Server generates a unique number using the IDENTITY keyword. This is the primary key field
It's all about SQL Server, MySQL, Oracle SQL*Plus, PostgreSQL, NoSQL, Hbase, Apache Pig, Apache Hive, Apache Sqoop, HDFS, MapReduce, ProxySQL, EC2, AWS and MongoDB
Big Data and SQL 