Set Auto number in Table Field in MS SQL Server 2008

Hi guy ! I would like to share how to set auto number in table field in SQL Server 2008. In this example, I have a table TblTransaction. A table field, TransactionID, I want to insert number automatically without typing value into it. So now, let's do it as step below :
 There are 2 steps:
        1. Click on field that you want to set auto number (make sure that Data Type of the field is int)
        2. In Column Properties, go to Identity Specification--> Is Identify : yes .
please see picture as below:
Set auto number to table field
Done...Hope this post is helpful for you...
Set Auto number in Table Field in MS SQL Server 2008 Set Auto number in Table Field in MS SQL Server 2008 Reviewed by BeiLover on 12:45 AM Rating: 5

No comments:

Powered by Blogger.