[Sql,Server中一次更新多列数据] excel数据透视表怎么做

UPATE yourTableName

SET column1 = xx, column2 = yy , column3 = zz

WHERE yourCondition

举个例子，比如有这样一张表：

表名：StudentInfo

UPATE StudentInfo

SET Name = "Small Bob", Age = 19

WHERE Number = "s1"

注意：单引号和都要是英文状态下的标点符号