sql server insert into,select into,delete,update,truncate

insert into tongxunlu (name,address,email) select sname,saddress,semail from students;

select students.sname,students.saddress,students.semail into tongxunlu from students;

select students.sname,students.saddress,students.semail,identity(int,1,1) as studentid into tongxunlu from students;

update students set scores=score+5 where score <= 95;

delete from students where scode=22;

truncate table students;