SQLÓï¾äÎÊÌâ

declare @a int

insert into tA select *,@a=@a+1 from tB

ÎÒÏëÔÚ±ítAÖмÓÒ»¸öÓÉ@a¸³ÖµµÄÐòºÅ£¨Õâ¸öÐòºÅÔÚÉϾäµÄÀý¾äÖмò»¯ÁË£¬Êµ¼ÊÉϵÄËã·¨ÉÔ¸´ÔÓ£© µ«ÊÇÕâ¾äSQL»á³ö´í¡£Õâ¸öÓï¾äÒªÔõÑùдÄØ£¿²»ÓÃÓαꡣ

лл¡£

---

Èç¹ûÏëÕâô¼ÓÐòºÅµÄ»°¾Í¸øÔ­±í¼ÓÒ»¸öÐÂÁаÉ
ALTER TB 
ADD NID INT
GO
DECLARE @A INT
UPDATE TB SET @A=@A+1,NID=@A

INSERT INTO TA SELECT ......,NID from TB

---

Èç¹ûÖ»ÊǼòµ¥µÄÅÅÐòÓÃROW_NUMBER¾ÍÐÐÁË

---

SQL code:
declare @a int

insert into tA select *,0 id from tB

update ta set id=@a,@a=@a+1

---

ÒýÓÃ

insert into ta select *,0 from tb
update ta
set col = @i ,@i=@i +1

ʯͷ´ó¸çºÃ,´¿ÊôÇɺÏ

---

¿ÉÒÔ¿¼ÂǼÓ×ÔÔöÁР
2000ÓÃidentity
2005ÓÃrow_number
ÒòΪÓñäÁ¿µÄЧÂÊʼÖÕ²»ÊÇÌ«¸ß