复制Declare @Id varchar(20) Declare @Id varchar(20) Declare @Name varchar(20) Declare Cur Cursor For select substring(id,简单0,7) as id,name from temp1 Open Cur Fetch next From Cur Into @Id,@Name While @@fetch_status=0 Begin Update temp Set [c3]=@Name where [id] like @Id+% Fetch Next From Cur Into @Id,@Name End Close Cur Deallocate Cur 1.2.3.4.5.6.7.8.9.10.11.12.13.14.