Explain Identity in SQL Server?
Submitted by: MuhammadIdentity (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.
Submitted by: Muhammad
Submitted by: Muhammad
Read Online MS SQL Server Joins Job Interview Questions And Answers
Top MS SQL Server Joins Questions
☺ | What is inner join? Explain with an example? |
☺ | What is Merge join? |
☺ | What is LEFT OUTER JOIN? |
☺ | What is OUTER JOIN? |
☺ | What is FULL OUTER JOIN? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |