sql ¸üÐÂijһÁÐ - MS-SQL Server / »ù´¡Àà

Êý¾Ý¿âÖÐÓÐÒ»ÁУ¬ÀïÃæµÄÖµ »ò¿Õ»òÓÐÖµ¡£
Ïë¸üÐÂÕâÒ»ÁУ¬½«¿ÕÖµµÄ²¿·ÖÌí¼ÓÊýÖµ£¬Ê¹¸üкóµÄÖµÓëÔ­À´µÄÖµ²»Öظ´£¬×îºÃÊÇÒÀ´ÎÔö³¤µÄ˳Ðò

---

¿ÉÒÔÊÔÊÔÓÃidentityº¯Êý

---

SQL code:
declare @i int
set @i=1
update tb set @i=@i+1,col=ltrim(@i) where col is null

---

¹ÜÀíÔ±ºÜÇ¿´ó£¡£¡

---

ѧϰÁË

---

ÒýÓÃ

SQL code
declare @i int
set @i=1
update tb set @i=@i+1,col=ltrim(@i) where col is null

²»´í

---

ÒýÓÃ

SQL code
declare @i int
set @i=1
update tb set @i=@i+1,col=ltrim(@i) where col is null

ºÇºÇ

---

ÒýÓÃ

SQL code
declare @i int
set @i=1
update tb set @i=@i+1,col=ltrim(@i) where col is null

!!!!!

---

лл´ó¼ÒµÄ¸úÌû£¬2Â¥ ¹ûÈ»ºÜÀ÷º¦¡£
лл£¬½áÌù£¬¶¥ÌùÕ߶¼ÓзÝ