adspace


What is identity column in sql server?

Answer Posted / Ashutosh Pratap Singh

An Identity Column in SQL Server is a special type of column that automatically generates unique numerical values for each row when it's inserted. This feature simplifies the process of inserting new records and ensuring they have a unique identifier.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key always clustered index?

1095


what are all the common sql function? : Sql dba

1131


what are the advantages of sql ? : Sql dba

1142


What is the current version of sql?

1094


how many tables will create when we create table, what are they? : Sql dba

1144


Does group by remove duplicates?

1112


Do we need to rebuild index after truncate?

1138


what is schema? : Sql dba

1147


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2091


How do I remove duplicates in two columns?

1187


What is the best sql course?

1050


Can delete statement be rollbacked?

1054


define sql insert statement ? : Sql dba

1098


what is sql server agent? : Sql dba

1182


If a cursor is open, how can we find in a pl/sql block?

1238