存储过程.sql

教材管理系统 asp设计本文主要介绍了基于JSP技术的电子商务动态网站

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