sqlserver中UPDATA怎么用的？

updata 表名 set …… 忘了这个set后面是写什么呢？

UPDATE 表名称 SET 列名称 = 新值 WHERe 列名称 = 某值

例如：
UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing'
WHERe LastName = 'Wilson';
UPDATE Person SET FirstName = 'Fred' WHERe LastName = 'Wilson'

update table名 set 列名=新值 where....懂了没？

dim cn as new adodb.connection   '数据库连接字符串   cn.connectionstring = "provider=sqloledb.1;integrated security=sspi;" _   & "persist security info=false;user id=sa;" _   & "initial catalog= database1;data source= localhost"   if cn.state <> adodb.objectstateenum.adstateclosed then cn.close   cn.open   dim rs as adodb.recordset   set rs = new adodb.recordset   with rs   set .activeconnection = cn   .cursorlocation = aduseclient   .cursortype = adopenkeyset   .locktype =adlockoptimistic    .open "select * from …… "'这里是你的sql语句(添加、删除、修改)   if .recordcount > 0 then   ……   end if   .close   end with