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