create table #t(name varchar(20),zishu int,firstword char(2)) go insert into #t(name) values ('safsdf') insert into #t(name) values ('cnjhmxv') insert into #t(name) values ('mhjmbvmf') insert into #t(name) values ('dfhhrthjf') insert into #t(name) values ('ghfghfg') insert into #t(name) values ('fyjutyj') goselect * from #t go update #t set zishu=len(name) ,firstword=left(name,1)
update tablename set zishu=len([name]), firstword=left([name],1)
update 一个表 set zishu=len(name),firstword=left(name,1)
一句就可以了. update 你的表 set zishu=len(name),firstword=left(name,1)
update tablename set zishu=datalength([name]), firstword=left([name],1)
update tablename set zishu=datalength([name]), firstword=left([name],1)
go
insert into #t(name) values ('safsdf')
insert into #t(name) values ('cnjhmxv')
insert into #t(name) values ('mhjmbvmf')
insert into #t(name) values ('dfhhrthjf')
insert into #t(name) values ('ghfghfg')
insert into #t(name) values ('fyjutyj')
goselect * from #t
go
update #t set zishu=len(name) ,firstword=left(name,1)
update 你的表 set zishu=len(name),firstword=left(name,1)