What is the difference between Identity and Auto-Increment command?

Posted by vishalneeraj-24503 on 3/6/2014 | Category: Sql Server Interview questions | Views: 7365 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Both performs the same operations and are used to add auto increment to a column in a table but Identity is used in Sql-Server whereas Auto-Increment command is used in MySql Database.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the best place to write content or control ...

Next > : Which command is used to add identity column in MY ...

Comments or Responses

More Interview Questions by vishalneeraj-24503

Which command is used to add identity column in MYSQL Database?
How to add auto-increment in an Existing tables in MYSQL database?
How to add auto-increment while creating tables in MYSQL database?
How to add auto-increment primary key in a existing table?
State differences between Primary key and Unique Key?
State similarities between Primary key and Unique Key?
How to assign Unique key to any column in the table at design time?
Can we have multiple Unique keys on the table?

Latest Interview Questions

Global.asax file can be downloaded via the Url like : www.samplewebsi ...
Global.asax file is mandatory in an application. True or False
How to stop flickering while the gets loaded in IE?
How to perform multiple file input?
Can multiple catch blocks that correspond to a single try block execut ...
How can you get the extension from a File upload control ?
How to perform sum of digits from 1 to n in javascript?
How can a user assign a property dynamically in javascript and generat ...
More ...