auto increment

HOW TO GIVE DATATYPE "AUTO INCREMENT" IN SQL SERVER?Add an identity column to your table.|||

Hi Kru,

Select the column whose datatype you want to be auto - increment. In the properties pane, find the IsIdentity property and set it to "Yes". optionally you can also select the Increment Seed i.e. Column value should be incremented by 1 or 2 or so on.

Jay Ho.