0 Members and 1 Guest are viewing this topic.

AuthorTopic: Auto increment primary key in SQL Server Management Studio 2012  (Read 1914 times)

Offline admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 771
  • Total Like : 0
    • https://www.facebook.com/pages/Phuket-ITcom/148070628616802
    • https://www.youtube.com/channel/UCq5x3hDkhcqJU4QXOE5adTQ
    • Email
« on: 26, 12, 2013, 17:00:59 »
Make sure that the Key column's datatype is int and then setting identity manually, as fifo's image show



http://stackoverflow.com/questions/10991894/auto-increment-primary-key-in-sql-server-management-studio-2012

กำหนดให้ Auto ID ใน MS SQL Server เหมือนกับ Auto Increment ใน MySQL ป้องกันปัญหาบันทึกแล้ว id ซ้ำหรือชนกัน
« Last Edit: 27, 12, 2013, 08:14:19 by admin »