sql2000 基本删除,插入,查询

insert into TABLE1 ([name],subject,class) values ('我的名字','英语',3)
select * from table1

insert into table1 (subject,class) values ('英语',3)
update table1 set [name]='' where isnull([name],'')=''

select * from table1 where class=2

select * from table1 where class>=2

select * from table1

delete table1 where class=1

update table1 set class=3 where class  is NULL