要是用的是sql server 數(shù)據(jù)庫(kù),在數(shù)據(jù)庫(kù)表中已經(jīng)把id作為自動(dòng)增長(zhǎng)(idengtity(1,1))類型了呢?怎么進(jìn)行增刪改查?
做項(xiàng)目的時(shí)候不是一般先設(shè)計(jì)數(shù)據(jù)庫(kù)嗎?
如果要是用的是sql server 數(shù)據(jù)庫(kù),在數(shù)據(jù)庫(kù)表中已經(jīng)把id作為自動(dòng)增長(zhǎng)(idengtity(1,1))類型了呢?怎么進(jìn)行增刪改查?
2016-11-11
SET IDENTITY_INSERT customers ON; ? ?//放開主鍵列的自增長(zhǎng)
...
...
操作
...
...
SET IDENTITY_INSERT customers OFF; ? //關(guān)閉IDENTITY_INSERT