MS SQL Server Joins Question:

Download Job Interview Questions and Answers PDF

Explain Identity in SQL Server?

SQL Server Joins Interview Question
SQL Server Joins Interview Question

Answer:

Identity (or Auto-Number) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers; the value of this cannot be controlled. Identity/GUID columns do not need to be indexed.

Download SQL Server Joins Interview Questions And Answers PDF

Previous QuestionNext Question
What is multi-statement table-value user-defined function?Explain dataWarehousing in SQL server?