二、DML语句

 

create database mydata

 

use mydata

go

 

create table stu

(

[name] varchar(10) not null,

age int,

score int not null,

phone char(11)

)

1,select

select * from stu

 

2,insert

insert into stu values('cheng',null,56,'11111')

 

insert stu([name],score,phone) values('zhao',57,'3333')

 

3,update

update stu set phone='1111' where [name]='cheng'

 

4.delete

delete from stu 

 

delete from stu where [name]='cheng'

 

5,truncate

truncate table stu

 

 

select 'mydb' 

 

declare @a int 

set @a=18

select @a

 

select @@version

 

select * from stu1

 

select * into stu1 from stu

 

select * into stu2 from stu where 1=2

select * from stu2

 

select * into stu3 from stu where [name]='wang'

select * from stu3

 

select [name],score into stu4 from stu

select * from stu4

 

select [name],score into stu5 from stu where [name]='cheng'

select * from stu5

 

insert into stu select * from stu1

select * from stu

 

insert into stu([name],score) select * from stu4 where [name]='cheng'

select * from stu1