存储过程.sql

来自「是一个教材管理系统」· SQL 代码 · 共 28 行

select * from tblBookAttribute

insert into tblBookAttribute values('征订')

insert into Admin values('admin3','')
select * from ##temp

create trigger InsertBookInfo
on tblBookInfo
for Insert
as
begin
 update tblBookIdTemp 
	set Id=(select inserted.ID from inserted);
end

create trigger InsertStorage
on tblBookStorage
for Insert
as
begin
 drop table ##temp;
end

drop table ##temp
select * from sysobjects where id = object_id(N'[dbo].[Admin]')and OBJECTPROPERTY(id, N'IsUserTable')=1

select * from ##temp