use test10
if exists (select name from sysobjects where name = 'author_infor')
drop proc author_infor
go
Create proc author_infor as
select *
from chengji
go

exec author_infor

1,错误：查询结果有俩个id,所以有冲突

create view testview2
as
select *
from student,  test10.dbo.chengji
where student.Id=  test10.dbo.chengji.id

下面是正确：
create view testview
as
select a.id
from test10.dbo.student as a LEFT   OUTER   JOIN test10.dbo.chengji as b
on a.id = b.id

错误：
1. 把‘错误弄成“
2. 字段名不需要引号

Insert into test10.dbo.student2 (Name) values ('kate1')

update student2
set name = 'lily'

where name = 'kate2'

delete *
from student2
where name = 'lily1'

11.10

学习如何在指定的数据库里建表

Creat table 数据库。用户名。表名字

such as
Create table test10.dbo.student2
(Id char(5), Name char(50))