Sql Server中一次更新多列数据

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

WHERE yourCondition

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

表名：StudentInfo

Name	Number	Age
Bob	s1	20
Lily	s2	20
John	s3	21

UPATE StudentInfo
SET Name = 'Small Bob', Age = 19

WHERE Number = 's1'

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