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. |
