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:
Done...Hope this post is helpful for you...
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 |
Set Auto number in Table Field in MS SQL Server 2008
Reviewed by BeiLover
on
12:45 AM
Rating:
Reviewed by BeiLover
on
12:45 AM
Rating:
No comments: