sqlsever2005语句

IF EXISTS (select * from dbo.sysobjects where Name = 'stuMarks')
drop table stuMarks
create table stuMarks
(
    id         int     identity(1,1) primary key,
    name       char(20) not null,
sex        char(20)not null,
phone      char(20)not null,
    address    char(40)     not null,
    email      char(20) not null,
)
go


insert into stuMarks values('zhangzhen','men','15172537121','wuhandaxue','2507797739')
insert into stuMarks values('zhangsan','men','12172537456','wuhandaxue','[e-mail]')
insert into stuMarks values('liuxioahan','female','187172537456','wuhandaxue','[e-mail]')
select * from stuMarks;


DELETE FROM stuMarks WHERE id=2;
update stuMarks set email='[e-mail]' where id='1';
select * from stuMarks where id=1;