sqlserver基础——更新字段，插入信息。

create table test 
(
ID int not null identity(1,1) primary key,--identity(初始值，增长值) primary key 设置主键
name varchar(50) not null,
address varchar(50) not null
)
insert into test (name,address) values ('张三','重庆')
insert into test (name,address) values ('李四','湖南')
insert into test select '王麻子','广州'
select * from test

--更新字段
update a set address='江西' from test a where name='张三' 
update test set name='小明' where address='江西'
select * from test