ÇóÒ»ÌõSQL¸üÐÂÓï¾ä

±íÓÐÁ½ÁÐ area_id  area_name
          1        ³¤É³
          2        ÔÀÑô
          4        ±±¾©
          6        Ïæ̶
            ¡­¡­¡­
            ¡­¡­¡­
            ¡­¡­¡­

ÎÒÏë°Ñarea_idµÄÄÚÈݸüУ¬´Ó1¿ªÊ¼ÖØÐÂÅÅÐò£¬1¡¢2¡¢3¡¢4¡¢5¡¢6¡¢7¡¢8¡¢9¡­¡­ ÇëÎÊÕâÌõÓï¾äÔõôд£¿

ÇëÖ¸½Ì£¡

---

SQL code:
alter table add id int identity(1,1)
update tb set area_id=id
alter column drop column id

---

SQL code:
DECLARE @NUM INT,@COUNT INT
UPDATE TB SET area_id=@NUM,@COUNT=@NUM+1

---

ÒýÓÃ

SQL codeDECLARE@NUMINT,@COUNTINTUPDATE TBSET area_id=@NUM,@COUNT=@NUM+1

Ū´íÁË,

---

ȱ¸öisnull

ÒýÓÃ

SQL codeDECLARE@NUMINT,@COUNTINTUPDATE TBSET area_id=@NUM,@COUNT=@NUM+1

---

alter table add id int identity(1,1)
update tb set area_id=id
alter column drop column