Get Identity Column Values without mentioning Identity Column Name in Select - SQL Tutorial Part 46

Описание: SQL Server / TSQL Tutorial Scenario: How to Get Identity Column Values without mentioning Identity Column Name in Select

You took a quick look on Table and Columns in SQL Server but could not find if Identity Property is enabled on one of the column. You don't want to use system tables to find out the column name if identity is enabled or not but want to get the column name with data. How would you do that?

Link to scripts used in the video
http://www.techbrothersit.com/2016/02...

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
http://www.techbrothersit.com/