userinsert.sql

实现了将图像目录保存在数据库中

create trigger USERINSERT on USERINFO for insert
as 
if exists (select * from inserted inner join USERINFO on inserted.UID=USERINFO.UID)
begin
insert into PHOTO(PID,PNAME)
select UID,UNAME from inserted
end