create trigger class_add_tg on class
for insert
as
begin
declare @classCode varchar(40),@className varchar(20)
set @className=(select inst.班级名 from inserted inst)
set @classCode='classStu'+@className
exec('create view '+@classCode+' as select * from stu where stu.班级=''' + @className +'''')
end
for insert
as
begin
declare @classCode varchar(40),@className varchar(20)
set @className=(select inst.班级名 from inserted inst)
set @classCode='classStu'+@className
exec('create view '+@classCode+' as select * from stu where stu.班级=''' + @className +'''')
end
解决方案 »
- 如何关闭所有表的自增
- 关于学生成绩的数据类型
- 请教怎么用存储过程批量修改
- 我想把库考出来怎么办呀
- 请问 MSSQL2000支持哪些操作系统,为什么我在 winxp个人版可以装服务端,
- 如何一条sql分页,无标识无主键、不用Row_number、不用存储过程、不用游标
- SQL SERVER2014打不开SSMS,有没有人和我一样?
- 这样的存储过程如何写??????????????????
- 请问按页数返回查询结果的SQL语句怎么写?
- sql server数据库命令中的dbcc是什么的缩写?
- 如何在全局临时表中能够将多条记录(一个字段)合并为一个???
- 关于建立索引的问题:“标题”字段是否应该建立索引??
create trigger class_add_tg on class
for insert
as
begin
Declare T_sc cursor for Select 班级名 from inserted
declare @classCode varchar(40),@className varchar(20)
open T_sc
fetch next from T_sc into @className
while @@FETCH_STATUS=0
begin
set @classCode='classStu'+@className
exec('create view '+@classCode+' as select * from stu where stu.班级=''' + @className +'''')
fetch next from T_sc into @className
end
close T_sc
deallocate T_sc
end
在表class中不能进行插入操作啊