仓健表
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'