15. 1. Identity |
| 15. 1. 1. | Using the IDENTITY Property and the IDENTITY() Function | | |
| 15. 1. 2. | Syntax for Using the IDENTITY() Function | | |
| 15. 1. 3. | Create table with IDENTITY column | | |
| 15. 1. 4. | Generating IDENTITY values | | |
| 15. 1. 5. | Cannot insert explicit value for identity column in table 'T' when IDENTITY_INSERT is set to OFF. | | |
| 15. 1. 6. | IDENTITY/NOT NULL/PRIMARY KEY | | |
| 15. 1. 7. | IDENTITY(100, 20) | | |
| 15. 1. 8. | Identity column | | |
| 15. 1. 9. | SELECT Statement and IDENTITY Property | | |
| 15. 1. 10. | Identity: A numerical value automatically assigned to a row any time a new row is added. | | |
| 15. 1. 11. | Supported data types for the IDENTITY property are TinyInt, SmallInt Int, BigInt, Decimal, and Numeric. | | |
| 15. 1. 12. | A table could also be created so that the seed value was negative and the increment was positive: | | |
| 15. 1. 13. | The IDENTITY property must be temporarily turned off when inserting a specific value. | | |
| 15. 1. 14. | SQL Server will choose the highest number as its current seed for a positive increment value or the lowest for a negative increment value. | | |
| 15. 1. 15. | Saving the @@IDENTITY Value in a Variable | | |
| 15. 1. 16. | SQL Server provides the @@IDENTITY global variable to hold that value. | | |
| 15. 1. 17. | Altering the Table to Add an Identity Column | | |
| 15. 1. 18. | Check @@IDENTITY value | | |
| 15. 1. 19. | Query a view with four table join | | |
| 15. 1. 20. | Retrieving the Maximum Value of key_col from MyTable | | |
| 15. 1. 21. | Query that Returns Result Row Numbers, Starting with 1 and Incrementing by 3 | | |
| 15. 1. 22. | Storing the Results in a Temporary Table Using the IDENTITY() Function | | |