SQL 4 sentence

仓健表

create table story

(story_id IDENTITY(50,1) not null PRIMARY KEY,

story_name char(10),

story_Desciption char(10)

)

修改表内容

ALTER TABLE story                                

ADD story_detail char(10) null

ALTER COLUMN story_name VCHAR(20)

Drop COLUMN story _Desciption

 删除表

Drop table story

存储过程

select * from employees where employName LIKE 'ba%'

insert into story(Company,phone) VALUES(N'comsas' ,N'pho22')

update story
set Company = 'alphacu'
where Company = 'alphac' 

delete from story

where Company = 'alphac'